Latest Episodes
343
Postgres Release Warning! | Scaling Postgres 343
In this episode of Scaling Postgres, we discuss new Postgres releases and an out-of-band release to address issues, increasing insert performance by 2X, pg_search...
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...