Re: pg_autovacuum entries - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: pg_autovacuum entries
Date
Msg-id 20091101175659.GB4428@alvh.no-ip.org
Whole thread Raw
In response to Re: pg_autovacuum entries  (Anj Adu <fotographs@gmail.com>)
Responses Re: pg_autovacuum entries  (Anj Adu <fotographs@gmail.com>)
List pgsql-admin
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.

pgsql-admin by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: pg_autovacuum entries
Next
From: Tom Lane
Date:
Subject: Re: dupes for PK and other UNIQUE indexes