Re: CLUSTER FREEZE - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: CLUSTER FREEZE
Date
Msg-id 5269B892.5060607@agliodbs.com
Whole thread Raw
In response to CLUSTER FREEZE  (Thomas Munro <munro@ip9.org>)
Responses Re: CLUSTER FREEZE  (Andres Freund <andres@2ndquadrant.com>)
Re: CLUSTER FREEZE  (Thomas Munro <munro@ip9.org>)
List pgsql-hackers
On 10/24/2013 04:55 PM, Robert Haas wrote:
> On Thu, Oct 24, 2013 at 1:09 PM, Josh Berkus <josh@agliodbs.com> wrote:
>> On 10/23/2013 09:58 PM, Amit Kapila wrote:
>>> I wonder why anyone would like to freeze during CLUSTER command when
>>> they already have separate way (VACUUM FREEZE) to achieve it, do you
>>> know or can think of any case where user wants to do it along with
>>> Cluster command?
>>
>> "If I'm rewriting the table anyway, let's freeze it".
>>
>> Otherwise, you have to write the same pages twice, if both CLUSTER and
>> FREEZE are required.
> 
> I wonder if we should go so far as to make this the default behavior,
> instead of just making it an option.

+1 from me.  Can you think of a reason you *wouldn't* want to freeze?

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: CLUSTER FREEZE
Next
From: Tom Lane
Date:
Subject: Re: Reasons not to like asprintf