mirror of
https://github.com/zulip/zulip.git
synced 2025-10-28 10:33:54 +00:00
feb7870db7
These thresholds are in relationship to the `autovacuum_freeze_max_age`, *not* the XID wraparound, which happens at 2^31-1. As such, it is *perfectly normal* that they hit 100%, and then autovacuum kicks in and brings it back down. The unusual condition is that PostgreSQL pushes past the point where an autovacuum would be triggered -- therein lies the XID wraparound danger. With the `autovacuum_freeze_max_age` set to 2000000000 in `postgresql.conf`, XID wraparound happens at 107.3%. Set the warning and error thresholds to below this, but above 100% so this does not trigger constantly.