Re: [DOCS] Autovacuum and XID wraparound - Mailing list pgsql-patches

From Alvaro Herrera
Subject Re: [DOCS] Autovacuum and XID wraparound
Date
Msg-id 20070515221347.GT12731@alvh.no-ip.org
Whole thread Raw
In response to Re: [DOCS] Autovacuum and XID wraparound  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [DOCS] Autovacuum and XID wraparound  ("Jim C. Nasby" <decibel@decibel.org>)
Re: [DOCS] Autovacuum and XID wraparound  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: [DOCS] Autovacuum and XID wraparound  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-patches
Tom Lane wrote:
> Alvaro Herrera <alvherre@commandprompt.com> writes:
> > I suppose it would be pretty trivial to set the relfrozenxid to
> > RecentXmin or something during TRUNCATE.
>
> I had the idea we were doing that already --- at least I'm pretty sure I
> remember it being discussed.  But I see it's not being done in HEAD.

Patch to do it attached.  I am thinking we can do something similar in
CLUSTER as well.

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

Attachment

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Doc and comment patch for packed varlena
Next
From: Bruce Momjian
Date:
Subject: Re: Maintaining cluster order on insert