Artwork

Content provided by [email protected] (Ruby Tree Software Inc) and Creston Jamison. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by [email protected] (Ruby Tree Software Inc) and Creston Jamison or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://player.fm/legal.
Player FM - Podcast App
Go offline with the Player FM app!

Postgres Sort Instability? | Scaling Postgres 322

19:48
 
Share
 

Manage episode 426426310 series 2140130
Content provided by [email protected] (Ruby Tree Software Inc) and Creston Jamison. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by [email protected] (Ruby Tree Software Inc) and Creston Jamison or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://player.fm/legal.

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/

  continue reading

324 episodes

Artwork
iconShare
 
Manage episode 426426310 series 2140130
Content provided by [email protected] (Ruby Tree Software Inc) and Creston Jamison. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by [email protected] (Ruby Tree Software Inc) and Creston Jamison or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://player.fm/legal.

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/

  continue reading

324 episodes

All episodes

×
 
Loading …

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.

 

Quick Reference Guide