Wrap around vacuum

From: elein <elein(at)varlena(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: elein <elein(at)varlena(dot)com>
Subject: Wrap around vacuum
Date: 2009-04-13 23:22:09
Message-ID: 16E1C36D-096E-4078-AAE4-E5FF969F8275@varlena.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Please copy elein(at)varlena(dot)com on responses. I am way behind on my
general mail.

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.

How can we do that?

elein
elein(at)varlena(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2009-04-13 23:55:55 Re: Wrap around vacuum
Previous Message Tom Lane 2009-04-13 22:58:34 Re: BUMP: Using foreign key constraint to eliminate unnecessary joins in view