background

Scaling PostgreSQL

A free weekly show on how to scale your PostgreSQL relational database.
Join over a thousand engineers keeping current on relevant Postgres content.

20,000 Times Faster Order By Limit | Scaling Postgres 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 an order by limit issue.

Here Comes Async I/O! | Scaling Postgres 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.

Scaling For High Volume | Scaling Postgres 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.

Top Ten Postgres Dos & Don'ts | Scaling Postgres 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 recovery.

Optimizing For Time-Series Data | Scaling Postgres 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.
Full Episode List