Re: CLUSTER FREEZE - Mailing list pgsql-hackers

From Robert Haas
Subject Re: CLUSTER FREEZE
Date
Msg-id CA+TgmobvKj=boVCC6HVZ1b0Ut37PrnWn9oGm7TF8uM=HNe6+Yw@mail.gmail.com
Whole thread Raw
In response to Re: CLUSTER FREEZE  (Josh Berkus <josh@agliodbs.com>)
Responses Re: CLUSTER FREEZE  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: CLUSTER FREEZE
Next
From: Josh Berkus
Date:
Subject: Re: CLUSTER FREEZE