Latest Episodes
367
How Often Does That Query Run? | Scaling Postgres 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...
366
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...
365
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...
364
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...
363
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...
362
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...