Scaling Postgres

Multigres Architecture | Scaling Postgres 418

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. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/418-multigres-architecture/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

• Transcript

11 Security Issues | Scaling Postgres 417

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. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/417-eleven-security-issues/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/

• Transcript

Zero Bloat Postgres Queue | Scaling Postgres 416

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. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/416-zero-bloat-postgres-queue/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-d

pgBackRest Is Dead? | Scaling Postgres 415

In this episode of Scaling Postgres, we discuss the notice of obsolescence for pgBackRest, the open source environment in general, queries to monitor autovacuum and pg_wait_tracer. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/415-pgbackrest-is-dead/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystif

Repack Concurrently | Scaling Postgres 414

In this episode of Scaling Postgres, we discuss repack concurrently coming to PG 19, how to design your schema, all about hints and enforcing constraints across partitions. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/414-repack-concurrently/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

Shard With One Command | Scaling Postgres 413

In this episode of Scaling Postgres, we discuss sharding your database with one command, more information about the Linux 7 Postgres performance regression, Xata going open source, and checkpoints and WAL storms. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/413-shard-with-one-command/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/c

Half as Fast on Linux 7 | Scaling Postgres 412

In this episode of Scaling Postgres, we discuss how Postgres may be half as fast on the new Linux 7 kernel, PostgresBench, what is missing in Postgres and WAL to distribute data. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/412-half-as-fast-on-linux-7/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demys

Absorbing Load | Scaling Postgres 411

In this episode of Scaling Postgres, we discuss techniques to absorb excessive query load, BM25 text search via pg_textsearch, good & bad CTEs and plan_cache_mode. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/411-absorbing-load/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/