Scale Through Sharding | Scaling Postgres 308

To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episo...

In this episode of Scaling Postgres, we discuss high availability's future, a custom sharding solution by Figma, sharding pg_vector queries, and PG17 logical replication fail over.

Want to learn more about Postgres performance?
Join my FREE mini-course called the PostgreSQL Performance Starter Kit here: https://www.scalingpostgres.com/cours...

Timestamps:
00:00 - Intro
00:49 - PG Phriday: Redefining Postgres High Availability
04:22 - How Figma’s databases team lived to tell the scale
07:40 - How Figma built DBProxy for sharding Postgres
08:00 - Distributed queries for pgvector
10:44 - Postgres 17 highlight: Logical replication slots synchronization
13:04 - Look ma, I wrote a new JIT compiler for PostgreSQL
15:01 - Postgres Performance Boost: HOT Updates and Fill Factor
16:19 - Waiting for PostgreSQL 17 – Add RETURNING support to MERGE.
16:59 - What the hell is transaction wraparound?
17:21 - superuser
17:48 - Outro

#postgres #postgresql