Podcast Episodes
Back to SearchEasy Incremental Data Processing? | Scaling Postgres 347
Episode 347
In this episode of Scaling Postgres, we discuss the new pg_incremental extension for processing data pipelines, a set of Postgres monitoring queries, handling alter table retries and large object dum…
Published on 11 months, 4 weeks ago
Things I Don't Do In Postgres | Scaling Postgres 346
Episode 346
In this episode of Scaling Postgres, we discuss things I do not do such as use default partitions, play column Tetris, ELT using special data types or create 7+ millions tables in a database.
To get …
Published on 1 year ago
Over 5X Faster Postgres? | Scaling Postgres 345
Episode 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 us track_planning.
To get the show…
Published on 1 year ago
Performance & Hard Things | Scaling Postgres 344
Episode 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 show notes as well as get notified of new …
Published on 1 year ago
Postgres Release Warning! | Scaling Postgres 343
Episode 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 benchmarks and fast OpenStreetMap lo…
Published on 1 year ago
Faster Writes With ZFS? | Scaling Postgres 342
Episode 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, denormalization and a new pgvector release.
To get th…
Published on 1 year, 1 month ago
The Future of Postgres Upgrades | Scaling Postgres 341
Episode 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.
To get the show notes as well as g…
Published on 1 year, 1 month ago
Do You Need A Vectorizer? | Scaling Postgres 340
Episode 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 and advanced psql.
To get the show notes as well as ge…
Published on 1 year, 1 month ago
Postgres Goes Parquet | Scaling Postgres 339
Episode 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 Postgres gotchas.
To get the show note…
Published on 1 year, 1 month ago
JSON Goodies In Postgres 17 | Scaling Postgres 338
Episode 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 get the show notes as well as get noti…
Published on 1 year, 2 months ago