Re: CLUSTER vs. VACUUM FULL

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: CLUSTER vs. VACUUM FULL
Дата
Msg-id CANzqJaCNn-Pd9Zyi4KvxbZ9qqR-ND9gUk1wgHKKYtxe0z7vh=w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: CLUSTER vs. VACUUM FULL  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: CLUSTER vs. VACUUM FULL  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
On Mon, Apr 22, 2024 at 4:21 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
[snip] 
Which gets us back to your comment upstream:

"What the VACUUM docs "should" do, it seems, is suggest CLUSTER on the
PK, if the PK is a sequence (whether that be an actual sequence, or a
timestamp or something else that grows monotonically)."

This is a case specific to you and this particular circumstance, not a
general rule for VACUUM FULL. If for no other reason then it might make
more sense for the application that the CLUSTER be done on some other
index then the PK.

On Stack Exchange, I've got a question on how to determine when to run CLUSTER.  It ties in strongly with this thread..

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: issue with reading hostname
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: CLUSTER vs. VACUUM FULL