| Lists: | pgsql-general |
|---|
| 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 |
| 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
| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | elein <elein(at)varlena(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Wrap around vacuum |
| Date: | 2009-04-13 23:55:55 |
| Message-ID: | 20090413235555.GL7709@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | 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