Avoid Angering the PostgreSQL Elder Gods
Talk by Keith Fiske
https://www.socallinuxexpo.org/scale/...
One of the most important administrative tasks for a PostgreSQL DBA is watching for Transaction ID Exhaustion, more commonly known as "Wraparound". Like the Lovecraftian elder gods, most users will rarely encounter it. But if you do, it's going to be a bad time. This talk will briefly go over the concept of transaction IDs, but will mostly be concentrating on monitoring for the exhaustion event and how to prevent it. Since this activity is tightly tied to the tuning of autovacuum, it also has a direct relation to methods that can help prevent awakening another sleeping giant, bloat.
Watch video Avoid Angering the PostgreSQL Elder Gods online without registration, duration hours minute second in high quality. This video was added by user Southern California Linux Expo 18 March 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 198 once and liked it 2 people.