Re: Wrap around vacuum - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Wrap around vacuum
Date
Msg-id 20090413235555.GL7709@alvh.no-ip.org
Whole thread Raw
In response to Wrap around vacuum  (elein <elein@varlena.com>)
List pgsql-general
elein wrote:

Hi Elein,

> autovacuum does special stuff when there is an approaching transaction
> wrap around.
> We have a lot of transactions and wrap around as much as once a week.
>
> We'd like to invoke vacuum to do the special stuff explicitly so that we
> can do it during lower traffic times.  Like weekends rather than
> weekdays.

What release are we talking about?  8.1, 8.2 and 8.3 are all different
in this regard.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: elein
Date:
Subject: Wrap around vacuum
Next
From: ahmed soua
Date:
Subject: how to disable autovaccum