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.
![ЛЕГИОНКА ДЕЛО ГОВОРИТ [DOTA2]](https://images.videosashka.com/watch/DHkwP_b-NiI)
