"Avoid Angering the Postgres Elder Gods" with Keith Fiske
Details
Join us virtually on April 10th, 2024 for "Avoid Angering the Postgres Elder Gods" with Keith Fiske.
One of the most important administrative tasks for a PostgreSQL DBA is keeping an eye out for Transaction ID Exhaustion, more commonly known as "xid wraparound". Like the Lovecraftian Elder Gods, most users will rarely, if ever, encounter it. But if you do, it's going to be a bad time. This metric is one of the most critical to monitor, since not accounting for it can lead to a full shutdown of the database for extended maintenance periods. Unfortunately, it is something you may not run into until your production systems have been running for years and it's no longer easy to have long outages.
This talk will briefly go over the concept of transaction IDs, but will mostly be concentrating on monitoring for the exhaustion event and actions to take 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 the awakening of another sleeping giant, table and index bloat. Keeping bloat under control is critical to peak query performance and maximizing the use of available storage.
Schedule:
12:00 PM Announcements, speaker introduction, presentation, Q&A.
1:15 PM Closing announcements, wrap up.
1:30 PM Event ends.
The link and detailed joining instructions, including the dial-in numbers for phone access, will be sent by email the day prior to the event, and posted on Meetup for those who have RSVPed "Yes".
General information about using GoToMeeting for this event can be found at: