Podcast Episodes

77 Times Faster In Postgres 17 | Scaling Postgres 337

Episode 337

In this episode of Scaling Postgres, we discuss how one query runs 77 times faster in Postgres 17, a detailed Postgres 17 performance webinar, using logical replication fail over slots and a discussi…

Published on 1 year, 2 months ago

More Postgres 17 Highlights | Scaling Postgres 336

Episode 336

In this episode of Scaling Postgres, we discuss more about the features released with Postgres 17, an example of performance improvements, things to watch out for, and the start of Postgres 18.

To ge…

Published on 1 year, 2 months ago

Postgres 17 Released! | Scaling Postgres 335

Episode 335

In this episode of Scaling Postgres, we discuss the release of Postgres 17, b-tree performance gains, logical replication enhancements and different levels of performance tuning.

To get the show note…

Published on 1 year, 2 months ago

Optimizing For Analytics | Scaling Postgres 334

Episode 334

In this episode of Scaling Postgres, we discuss how to optimize your database for analytics, how to speed up counts, improvements to TimescaleDB and why you should stop using serial.

To get the show …

Published on 1 year, 2 months ago

When Select Writes! | Scaling Postgres 333

Episode 333

In this episode of Scaling Postgres, we discuss when select can write, Postgres RC1 is released, Tetris in SQL and copy, swap, drop.

To get the show notes as well as get notified of new episodes, vis…

Published on 1 year, 3 months ago

Sometimes It Is Slow? | Scaling Postgres 332

Episode 332

In this episode of Scaling Postgres, we discuss what can happen when queries get slow, backup best practices, Postgres emergencies and the state of Postgres survey.

To get the show notes as well as g…

Published on 1 year, 3 months ago

Is pg_dump A Backup Tool? | Scaling Postgres 331

Episode 331

In this episode of Scaling Postgres, we discuss whether pg_dump is a backup tool, the pgMonitor extension, Postgres malware, and application uses for the merge command.

To get the show notes as well …

Published on 1 year, 3 months ago

Splicing Elephant & Duck DNA | Scaling Postgres 330

Episode 330

In this episode of Scaling Postgres, we discuss the merging of Postgres and DuckDB via the pg_duckdb extension, how this can help the analytics story for Postgres, some ways to improve PG analytics a…

Published on 1 year, 3 months ago

PGlite: Embeddable Postgres & postgres.new | Scaling Postgres 329

Episode 329

In this episode of Scaling Postgres, we discuss PGlite, an embeddable Postgres, postgres.new which adds AI features, new Postgres releases and the performance of synchronous replication.

To get the s…

Published on 1 year, 4 months ago

Implement Get Or Create | Scaling Postgres 328

Episode 328

In this episode of Scaling Postgres, we discuss different get or create implementations, a new pgBouncer version, alter default privileges, and six degrees of separation with Postgres.

To get the sho…

Published on 1 year, 4 months ago