Re: autovacuum, xid wraparound, pg_database column values - Mailing list pgsql-general

From Tom Lane
Subject Re: autovacuum, xid wraparound, pg_database column values
Date
Msg-id 29728.1149690470@sss.pgh.pa.us
Whole thread Raw
In response to autovacuum, xid wraparound, pg_database column values  ("shakahshakah@gmail.com" <shakahshakah@gmail.com>)
List pgsql-general
"shakahshakah@gmail.com" <shakahshakah@gmail.com> 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

pgsql-general by date:

Previous
From: "Magnus Hagander"
Date:
Subject: Re: Can PostGreSQL slow down a Windows PC much?
Next
From: Tom Lane
Date:
Subject: Re: Problem with 'postgres' db with 8.0 on a MacBook