Latest Episodes
391
Table Lock Explosion! | Scaling Postgres 391
In this episode of Scaling Postgres, we discuss the issues of partition locking during planning, the problem of too much memory, the importance of...
390
1.2 Million Messages Per Second | Scaling Postgres 390
In this episode of Scaling Postgres, we discuss how far Postgres can scale with queue and pub/sub workloads, temporal joins, IPC:SyncRep and nested partitioning....
389
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...
388
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...
387
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,...
368
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...