To: Heikki Linnakangas <heikki@enterprisedb.com>
cc: Alvaro Herrera <alvherre@commandprompt.com>,
	Chris Browne <cbbrowne@acm.org>, pgsql-patches@postgresql.org
Subject: Re: [DOCS] Autovacuum and XID wraparound 
In-reply-to: <464B6B08.6030609@enterprisedb.com> 
References: <20070514011740.GH14860@fetter.org>
	<23394.1179108400@sss.pgh.pa.us> <1179117269.6047.3.camel@goldbach>
	<60sl9z6tln.fsf@dba2.int.libertyrms.com>
	<20070514221619.GC8916@alvh.no-ip.org>
	<857.1179184222@sss.pgh.pa.us>
	<20070515221347.GT12731@alvh.no-ip.org>
	<23362.1179292856@sss.pgh.pa.us>
	<20070516124420.GA4582@alvh.no-ip.org>
	<464B0E5A.1070807@enterprisedb.com> <6549.1179344646@sss.pgh.pa.us>
	<464B60A7.3070106@enterprisedb.com> <7145.1179347418@sss.pgh.pa.us>
	<464B6B08.6030609@enterprisedb.com>
Comments: In-reply-to Heikki Linnakangas <heikki@enterprisedb.com>
	message dated "Wed, 16 May 2007 21:35:20 +0100"
Date: Wed, 16 May 2007 17:01:12 -0400
Message-ID: <7460.1179349272@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

Heikki Linnakangas <heikki@enterprisedb.com> writes:
> Tom Lane wrote:
>> ... I have resisted having VACUUM freeze
>> tuples before they've reached a quite-respectable age, and I object to
>> having CLUSTER do it either.

> How about freezing anything older than vacuum_freeze_min_age, just like 
> VACUUM does?

I suppose that'd be OK, but is it likely to be worth the trouble?

>> I could maybe accept a CLUSTER FREEZE option to do this, but that's not
>> what's in the patch.

> I wouldn't like to add more options to CLUSTER, people are already 
> confused about the similar VACUUM options.

Agreed, I wasn't thrilled with that idea.

			regards, tom lane