From: | Anj Adu <fotographs(at)gmail(dot)com> |
---|---|
To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
Cc: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: XID wraparound in 8.4 |
Date: | 2009-10-13 21:51:42 |
Message-ID: | f2fd819a0910131451y4e433470q35107f1248e7fef2@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Assuming that autovacuum is off in 8,2 and upwards versions, would I
still have to do a database-wide vacuumdb OR would vacuuming
individual tables that are permanent be sufficient to take care of XID
wraparound?
2009/8/11 Alvaro Herrera <alvherre(at)commandprompt(dot)com>:
> Anj Adu escribió:
>> Reason we dont turn on autovacuum is that we are a "high-volume"
>> insert shop with minimal updates..We have about 200 million inserts
>> and a few thousand updates only. Most tables are partitions and get
>> dropped as part of the purge. Hence..autovacuum is a waste of
>> resources. However...the XID issue will force the need for an
>> autovacuum at some point..hence we do it as a one-off occasionally.
>
> Hmm, in 8.2 you won't need to vacuum any tables that you drop or
> truncate. Only permanent tables will need to be vacuumed once in a
> while.
>
> --
> Alvaro Herrera http://www.CommandPrompt.com/
> The PostgreSQL Company - Command Prompt, Inc.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2009-10-13 22:01:47 | Re: XID wraparound in 8.4 |
Previous Message | Michael Graziano | 2009-10-13 18:48:53 | Re: Warm standby questions |