Latest Episodes
342
Faster Writes With ZFS? | Scaling Postgres 342
In this episode of Scaling Postgres, we discuss the read and write performance of Postgres on ZFS, handling URL text identifiers in the database,...
341
The Future of Postgres Upgrades | Scaling Postgres 341
In this episode of Scaling Postgres, we discuss the future of Postgres upgrades, the usefulness of pg_dump, partitioning with minimal downtime and limitless Aurora....
340
Do You Need A Vectorizer? | Scaling Postgres 340
In this episode of Scaling Postgres, we discuss whether you need a vectorizer, different ways to bin or bucket timestamps, addressing a bad plan...
339
Postgres Goes Parquet | Scaling Postgres 339
In this episode of Scaling Postgres, we discuss pg_parquet allowing Postgres to read and write parquet files, other useful extensions, open source bounties, and...
338
JSON Goodies In Postgres 17 | Scaling Postgres 338
In this episode of Scaling Postgres, we discuss the JSON goodies in Postgres 17, trigger recursion, pg_dump as backup and pg_timeseries columnar performance. To...
337
77 Times Faster In Postgres 17 | Scaling Postgres 337
In this episode of Scaling Postgres, we discuss how one query runs 77 times faster in Postgres 17, a detailed Postgres 17 performance webinar,...