Go offline with the Player FM app!
Postgres Sort Instability? | Scaling Postgres 322
Manage episode 426426310 series 2140130
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/
330 episodes
Manage episode 426426310 series 2140130
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/
330 episodes
All episodes
×Welcome to Player FM!
Player FM is scanning the web for high-quality podcasts for you to enjoy right now. It's the best podcast app and works on Android, iPhone, and the web. Signup to sync subscriptions across devices.