Re: [DOCS] Autovacuum and XID wraparound

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Chris Browne <cbbrowne(at)acm(dot)org>, pgsql-patches(at)postgresql(dot)org
Subject: Re: [DOCS] Autovacuum and XID wraparound
Date: 2007-05-16 05:20:56
Message-ID: 23362.1179292856@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-patches

Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> Tom Lane wrote:
>> 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.

Umm ... you'd have to be a lot more conservative in CLUSTER now that
it's MVCC-safe. I don't say that CLUSTER can't push up relfrozenxid,
but there's something wrong if CLUSTER and TRUNCATE are trying to
push it up the same amount.

regards, tom lane

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Guillaume Cottenceau 2007-05-16 07:41:46 Re: [doc patch] a slight VACUUM / VACUUM FULL doc improvement proposal
Previous Message Alvaro Herrera 2007-05-16 02:02:18 Re: [DOCS] Autovacuum and XID wraparound

Browse pgsql-patches by date

  From Date Subject
Next Message Heikki Linnakangas 2007-05-16 08:12:23 Re: [PATCHES] OS/X startup scripts
Previous Message Bruce Momjian 2007-05-16 03:20:25 Re: actualised forgotten Magnus's patch for plpgsql MOVE statement