Re: Minimally avoiding Transaction Wraparound in VLDBs - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Minimally avoiding Transaction Wraparound in VLDBs
Date
Msg-id 20050901014804.GA18701@surnet.cl
Whole thread Raw
In response to Re: Minimally avoiding Transaction Wraparound in VLDBs  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
On Thu, Sep 01, 2005 at 01:57:02AM +0100, Simon Riggs wrote:

> > If you're using autovacuum then the problem is already taken care of.
> 
> autovacuum will respond only to UPDATEs and DELETEs. In the scenario I
> outline, these will *never* occur on the largest tables. A VACUUM would
> still eventually be required to freeze long lived tuples and this would
> not be performed by autovacuum.

Hum, I don't understand -- if you don't want to vacuum the table, why
run vacuum at all?  You can (as of 8.1) disable autovacuum for specific
tables.  The exception is that you are forced to run a database-wide
VACUUM once in a while (every billion-and-so), but this will hopefully
disappear in 8.2 too, leaving you effectively with the option of never
vacuuming a table.

-- 
Alvaro Herrera -- Valdivia, Chile         Architect, www.EnterpriseDB.com
You liked Linux a lot when he was just the gawky kid from down the block
mowing your lawn or shoveling the snow. But now that he wants to date
your daughter, you're not so sure he measures up. (Larry Greenemeier)


pgsql-hackers by date:

Previous
From: ITAGAKI Takahiro
Date:
Subject: Remove xmin and cmin from frozen tuples
Next
From: Tom Lane
Date:
Subject: Re: Indexing dead tuples