Scale Through Sharding | Scaling Postgres 308

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.

Content Discussed

• PG Phriday: Redefining Postgres High Availability
• How Figma’s databases team lived to tell the scale
• How Figma built DBProxy for sharding Postgres
• Distributed queries for pgvector
• Postgres 17 highlight: Logical replication slots synchronization
• Look ma, I wrote a new JIT compiler for PostgreSQL
• Postgres Performance Boost: HOT Updates and Fill Factor
• Waiting for PostgreSQL 17 – Add RETURNING support to MERGE.
• What the hell is transaction wraparound?
• superuser
• Examining Postgres Upgrades with pg_upgrade
• Inside PostGIS: Calculating Distance
• Extension Registry Namespacing RFC
• PostgreSQL Internals Part 1: Understanding Database Cluster, Database and Tables
• Understanding the PostgreSQL Query Planner to Improve Query Performance
• The Security Talk Maiden Voyage
• Florent Jardin
• Mini Summit One
• Back from pgDay Paris 2024.
• Talk: Building Trunk
• pgagroal command refactoring (again!) and a new contributor!
• PgTraining Online Event 2024 (italian)
• How We Made Real-Time Data Aggregation in Postgres Faster by 50,000%
• EDB Releases Continuous High Availability Solution With Postgres for Kubernetes
• Enterprise-grade Replication from Postgres to Azure Event Hubs

YouTube Video

Podcast Audio