Re: XID wraparound in 8.4 - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: XID wraparound in 8.4
Date
Msg-id 20090811220427.GJ16362@alvh.no-ip.org
Whole thread Raw
In response to Re: XID wraparound in 8.4  (Devrim GÜNDÜZ <devrim@gunduz.org>)
Responses Re: XID wraparound in 8.4
Re: XID wraparound in 8.4
List pgsql-admin
Devrim GÜNDÜZ escribió:

> FWIW, PostgreSQL 8.3+ will start autovacuum (even if it is turned off)
> if a database is approaching XID wraparound, and get rid of the
> problem-- so you don't actually need to check it.

8.1 does it too.  The main difference is that 8.1 will run a
database-wide vacuum, whereas in 8.2 and up it only vacuum tables that
have not been vacuumed recently.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-admin by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: XID wraparound in 8.4
Next
From: Anantha V Padmanaban
Date:
Subject: Space usage