On Nov 21, 2006, at 1:29 PM, Tom Lane wrote:
Casey Duncan <casey@xxxxxxxxxxx> writes:
- The autovac daemon doesn't initiate a database-wide vacuum until
100,000 txns before the txn id warning hits. In my case this gives
only a few minutes under peak load.
I believe this problem is largely addressed for 8.2; see
http://developer.postgresql.org/pgdocs/postgres/routine-
vacuuming.html#VACUUM-FOR-WRAPAROUND
The default autovac interval is a lot more conservative than it was
before (200M transactions), and you can tune things if you need to.
Cool, I think I'll patch my 8.1 autovac for now to be more
conservative, that'll get me by until I can get on 8.2.
Thanks!
-Casey
