Re: CLUSTER FREEZE

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: CLUSTER FREEZE
Дата
Msg-id CA+TgmobvKj=boVCC6HVZ1b0Ut37PrnWn9oGm7TF8uM=HNe6+Yw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: CLUSTER FREEZE  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: CLUSTER FREEZE  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Re: CLUSTER FREEZE
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: CLUSTER FREEZE