A free weekly show on how to scale your PostgreSQL relational database.Join over a thousand engineers keeping current on relevant Postgres content.
In this episode of Scaling Postgres, we discuss scaling out application writes to achieve 226K TPS, try to avoid delete, disaster recovery is a process and avoid NULL in your NOT IN.
In this episode of Scaling Postgres, we discuss scale out Postgres projects getting more funding, getting started with Postgres 19 Beta 1 along with its top features and how to review a Postgres patch.
In this episode of Scaling Postgres, we discuss the release of Postgres 19 Beta 1, optimizing autovacuum, the release of Multigres 0.1 Alpha 1, and handling graph queries in Postgres.
In this episode of Scaling Postgres, we discuss the dynamic duo of foreign tables and materialized views, the dangers of long-running transactions and job queues and why we cannot have transparent data encryption.
In this episode of Scaling Postgres, we go over the architecture of Multigres (Vitess for Postgres), pgBackRest's status, pg_flight_recorder and general SQL optimizations.