Re: CLUSTER ALL syntax

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: CLUSTER ALL syntax
Дата
Msg-id 7099.1037569321@sss.pgh.pa.us
обсуждение исходный текст
Ответ на CLUSTER ALL syntax  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: CLUSTER ALL syntax  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Re: CLUSTER ALL syntax  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> In looking at the CLUSTER ALL patch I have applied, I am now wondering
> why the ALL keyword is used.  When we do VACUUM, we don't use ALL. 
> VACUUM vacuums all tables.  Shouldn't' CLUSTER alone do the same thing. 

I agree, lose the ALL.

> And what about REINDEX?  That seems to have a different syntax from the
> other two.  Seems there should be some consistency.

We don't have a REINDEX ALL, and I'm not in a hurry to invent one.
(Especially, I'd not want to see Alvaro spending time on that instead
of fixing the underlying btree-compaction problem ;-))
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg_stat_database shows userid as OID
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: CLUSTER ALL syntax