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.
Смотрите видео Avoid Angering the PostgreSQL Elder Gods онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Southern California Linux Expo 18 Март 2023, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 198 раз и оно понравилось 2 людям.