Description
In this episode of Scaling Postgres, we discuss an incremental sort instability issue with the Postgres planner, whether we should use foreign keys, how the visibility map works and how to vacuum the template0 database.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/322-postgres-sort-instability/
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,...
Published 11/17/24
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,...
Published 11/10/24