Scaling Postgres

In this episode of Scaling Postgres, we discuss whether the future of containers and Postgres, UUIDv7 commit, and a pg_duckdb interview.

To get the show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/348-the-future-is-containers/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

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 dump performance.

To get the show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/347-easy-incremental-data-processing/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

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 the show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/346-things-i-do-not-do-in-postgres/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

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 notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/345-over-5x-faster-postgres/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

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 episodes, visit: 
https://www.scalingpostgres.com/episodes/344-performance-hard-things/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

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 loading.

To get the show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/343-postgres-release-warning/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

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 the show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/342-faster-writes-with-zfs/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

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 get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/341-the-future-of-postgres-upgrades/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

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 get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/340-do-you-need-a-vectorizer/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

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 notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/339-postgres-goes-parquet/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/