Scaling Postgres

00:15:22

Too Many Table Danger | Scaling Postgres 424

Scaling Postgres ·

2026/07/05

In this episode of Scaling Postgres, we discuss the dangers of too many tables, don't worry about extending checkpoint_timeout, a disaster recovery process, and non-repeatable sums with floating point numbers. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/424-too-many-table-danger/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified

en

00:14:55

New Backup Tool | Scaling Postgres 423

Scaling Postgres ·

2026/06/28

In this episode of Scaling Postgres, we discuss a new backup tool called pg_hardstorage by Cybertech, bottomless storage & ColdFront, monitoring checkpoints and tracking statistics. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/423-new-backup-tool/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here:

en

00:13:26

Scaling Out To 226K TPS | Scaling Postgres 422

Scaling Postgres ·

2026/06/21

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

en

00:09:41

Scale Out Funding | Scaling Postgres 421

Scaling Postgres ·

2026/06/14

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

en

00:09:41

Scale Out Funding | Scaling Postgres 421

Scaling Postgres ·

2026/06/14

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

en

00:18:57

Postgres 19 Beta 1 Released | Scaling Postgres 420

Scaling Postgres ·

2026/06/07

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

en

00:18:57

Postgres 19 Beta 1 Released | Scaling Postgres 420

Scaling Postgres ·

2026/06/07

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

en

00:15:39

The Dynamic Duo? | Scaling Postgres 419

Scaling Postgres ·

2026/05/31

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/419-dynamic-duo/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here:

en

00:16:51

Multigres Architecture | Scaling Postgres 418

Scaling Postgres ·

2026/05/24

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:

en

00:16:51

Multigres Architecture | Scaling Postgres 418

Scaling Postgres ·

2026/05/24

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:

en

00:19:56

11 Security Issues | Scaling Postgres 417

Scaling Postgres ·

2026/05/17

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:

en

00:19:56

11 Security Issues | Scaling Postgres 417

Scaling Postgres ·

2026/05/17

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:

en

00:15:09

Zero Bloat Postgres Queue | Scaling Postgres 416

Scaling Postgres ·

2026/05/10

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:

en

00:15:09

Zero Bloat Postgres Queue | Scaling Postgres 416

Scaling Postgres ·

2026/05/10

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:

en

00:16:26

pgBackRest Is Dead? | Scaling Postgres 415

Scaling Postgres ·

2026/05/03

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:

en

00:19:55

Repack Concurrently | Scaling Postgres 414

Scaling Postgres ·

2026/04/26

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:

en

00:19:55

Repack Concurrently | Scaling Postgres 414

Scaling Postgres ·

2026/04/26

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:

en

00:19:52

Shard With One Command | Scaling Postgres 413

Scaling Postgres ·

2026/04/19

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

en

00:15:31

Half as Fast on Linux 7 | Scaling Postgres 412

Scaling Postgres ·

2026/04/12

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:

en

00:15:31

Half as Fast on Linux 7 | Scaling Postgres 412

Scaling Postgres ·

2026/04/12

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:

en

All Episodes

Similar Podcasts

Lead With AI

Tamara Nall

Elon Musk Podcast

Stage Zero

Modem Futura

Sean Leahy, Andrew Maynard

Cisco Podcast Network

Cisco

MSP Business School

MSP Business School