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@commandprompt.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.
>