Latest Episodes
345

Over 5X Faster Postgres? | Scaling Postgres 345
In this episode of Scaling Postgres, we discuss OrioleDB getting Postgres over 5 times faster, historical OLAP performance, efficient queries and whether you should...
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...