"shakahshakah@xxxxxxxxx" <shakahshakah@xxxxxxxxx> writes: > I'm trying to make sense of Section 22.1.3 ("Preventing transaction ID > wraparound failures") in the on-line docs to make sure the DB's > autovacuum settings are adequate and are having an effect. > ... > I don't see numbers larger than 1 billion in my pg_database columns, > though. The pg_database columns only update when you do a database-wide VACUUM, which is something that autovacuum only undertakes when it sees that the age values are getting large. I forget the exact threshold, but at ~28M transactions you are certainly a long way away. regards, tom lane