Podcast Episodes

How Often Does That Query Run? | Scaling Postgres 367

Episode 367

In this episode of Scaling Postgres, we discuss a Postgres VS code extension, service definition files, undead tuples and the benefits of finding out how often a query is run.

To get the show notes a…

Published on 6 months, 3 weeks ago

20,000 Times Faster Order By Limit | Scaling Postgres 366

Episode 366

In this episode of Scaling Postgres, we discuss a top ten dangerous Postgres issues list, importing and exporting statistics, more Postgres 18 beta features and a 20,000 times faster query by fixing …

Published on 7 months ago

Here Comes Async I/O! | Scaling Postgres 365

Episode 365

In this episode of Scaling Postgres, we discuss async I/O introduced in PG 18 Beta 1, new Postgres releases, PgDog performance and innovative ways to optimize queries.

To get the show notes as well a…

Published on 7 months, 1 week ago

Scaling For High Volume | Scaling Postgres 364

Episode 364

In this episode of Scaling Postgres, we discuss scaling for high volume, why workflows should be Postgres rows, a planner gotcha and ways to resolve planner issues.

To get the show notes as well as g…

Published on 7 months, 2 weeks ago

Top Ten Postgres Dos & Don'ts | Scaling Postgres 363

Episode 363

In this episode of Scaling Postgres, we discuss a top ten dos and don't for Postgres, understanding statistics and extended statistics, aligning columns to reduce padding and how to handle disaster r…

Published on 7 months, 3 weeks ago

Optimizing For Time-Series Data | Scaling Postgres 362

Episode 362

In this episode, we discuss optimizing for time-series data, indexing vectors, Postgres APT extension packaging and how to optimize queries involving low cardinality data columns.

To get the show not…

Published on 8 months ago

A Roadmap To Scaling Postgres | Scaling Postgres 361

Episode 361

In this episode of Scaling Postgres, we discuss a roadmap to scaling Postgres, life altering Postgres patterns, making Postgres better with OrioleDB, performance cliffs and efficient use of foreign k…

Published on 8 months, 1 week ago

Handle One Million Connections? | Scaling Postgres 360

Episode 360

In this episode of Scaling Postgres, we discuss how a new tool pgDog might allow one million client connections to Postgres, novel use cases for pgvector other than semantic search, don't expose port…

Published on 8 months, 2 weeks ago

Trillions of Rows & Metrics | Scaling Postgres 359

Episode 359

In this episode of Scaling Postgres, we talk about indexes being added to Timescale's column store, processing 1 trillion metrics in Timescale, processing 1 trillion rows in Citus and partitions for …

Published on 8 months, 3 weeks ago

Postgres Conference 2025 | Scaling Postgres 358

Episode 358

In this episode of Scaling Postgres, I discuss my experience attending Postgres Conference 2025 and cover some of the highlights of the conference. Interestingly, at least from my perspective, the mo…

Published on 8 months, 4 weeks ago