Re: CLUSTER FREEZE - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: CLUSTER FREEZE
Date
Msg-id 5269542C.5080509@agliodbs.com
Whole thread Raw
In response to CLUSTER FREEZE  (Thomas Munro <munro@ip9.org>)
Responses Re: CLUSTER FREEZE
Re: CLUSTER FREEZE
List pgsql-hackers
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.

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



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: [PATCH] Use MAP_HUGETLB where supported (v3)
Next
From: Josh Berkus
Date:
Subject: Re: Add min and max execute statement time in pg_stat_statement