Latest Episodes
344
Performance & Hard Things | Scaling Postgres 344
In this episode of Scaling Postgres, we discuss new releases, collation speed, ZFS performance, insert benchmarking and pglz vs. lz4 performance. To get the...
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...