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.

Heavy Reader or Writer? | Scaling Postgres 389

In this episode of Scaling Postgres, we discuss ways to optimize reading or writing, the benefits of a descending index, more information about lightweight locks and a backup public service announcement.

NVME Wins? | Scaling Postgres 388

In this episode of Scaling Postgres, we discuss PG17 and PG18 benchmarks across storage types, more about Postgres locks, sanitizing SQL and can a faster software & hardware environment cause performance problems?

Boosting Planning Performance | Scaling Postgres 387

In this episode of Scaling Postgres, we explore how PG18 locking changes can boost planning performance, how to store data safely on a budget, how to build a parquet file archive solution and we discuss the completion of the summer of upgrades.

Postgres 18: The Deep Cuts | Scaling Postgres 386

In this episode of Scaling Postgres, we discuss additional Postgres 18 features, some future features for Postgres, how to use update with limit and how recent Ubuntu OS patches cause a Postgres restart.

Postgres 18 Released! | Scaling Postgres 385

In this episode of Scaling Postgres, we discuss the release of Postgres 18 and cover different features such as asynchronous I/O, enhanced return from statements, parallel apply, adding not null as not valid and more!

Full Episode List