To get the show notes as well as get notified of new episodes, visit:
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: 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