Re: pg_autovacuum and VACUUM FREEZE - Mailing list pgsql-hackers

From Rod Taylor
Subject Re: pg_autovacuum and VACUUM FREEZE
Date
Msg-id 1066313801.26276.4.camel@jester
Whole thread Raw
In response to Re: pg_autovacuum and VACUUM FREEZE  ("Matthew T. O'Connor" <matthew@zeut.net>)
Responses Re: pg_autovacuum and VACUUM FREEZE  ("Matthew T. O'Connor" <matthew@zeut.net>)
List pgsql-hackers
> The vacuum man page says, "FREEZE is not recommnded for routine use".
> That was enough to keep me away.  However if vacuum freeze was
> considerably lighter than normal database wide vacuums then there might
> be an advantage to using it.  Especially since when pg_autovaccum
> decides it's time to deal with xid wraparound, it does it to all the
> databases, which could a several hours of vacuum on large clusters.

Each database has it's own last xid. Just because one database is about
to go over the limit doesn't mean they all are.  Why don't you treat
each database independently in this regard (then they wouldn't
necessarily all be kicked off at once).

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Still a few flaws in configure's default CFLAGS
Next
From: Christopher Browne
Date:
Subject: Re: Database Kernels and O_DIRECT