Scaling Postgres

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-demystified/

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-demystified/

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/

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/courses/postgres-performance-demystified/

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-demystified/