Scale Through Sharding | Scaling Postgres 308

To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/308-scale-through-sharding/ 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/courses/postgresql-performance-starter-kit/ 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