If I were to use autovacuum on 8.1 , and If I specify the "ignore'
tables in pg_autovacuum,
1. will the XID wraparound counter be reset after autovacuum finishes
2. If some of the ignore tables are never dropped or deleted in the
future...how do the transaction semantics work with the rows in these
tables (this is not likely to happen..but I am curious to know how
transaction semantics work with the data in these tables)
On Sun, Nov 1, 2009 at 9:56 AM, Alvaro Herrera
> Anj Adu escribió:
>> My goal is to reset the XID wraparound counter by performing vacuumdb
>> (autovacuum is not an option for my for various reasons)
> Note that if you are on 8.1 (I can't recall) you need to vacuum the
> whole database in a single command for Xid wraparound. Only on 8.2 and
> higher you can get away with doing it one table at a time.
> Alvaro Herrera http://www.CommandPrompt.com/
> The PostgreSQL Company - Command Prompt, Inc.
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
In response to
pgsql-admin by date
|Next:||From: Alvaro Herrera||Date: 2009-11-04 20:00:00|
|Subject: Re: pg_autovacuum entries|
|Previous:||From: Isabella Ghiurea||Date: 2009-11-04 18:17:15|
|Subject: overwrite permissions on default tablespace|