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 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.
In this episode of Scaling Postgres, we discuss new Postgres releases that patch eleven security issues, a new pgbouncer release patching four security issues, making JSON queryable, and issues with views.
In this episode of Scaling Postgres, we discuss a new zero bloat Postgres queue called PgQue, maybe pgBackRest isn't dead, multixact members at 64 bits and using session variables.
