Re: CLUSTER details

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: CLUSTER details
Дата
Msg-id CAKFQuwbA+NYKBqOkBXDfDO19VBs-t-qsanoC+n6cYA3dRZH+Mg@mail.gmail.com
обсуждение исходный текст
Ответ на CLUSTER details  (PG Doc comments form <noreply@postgresql.org>)
Ответы Re: CLUSTER details  ("Bernd Eckenfels" <ecki@zusammenkunft.net>)
Список pgsql-docs
On Fri, Jun 7, 2024, 10:57 Bernd Eckenfels <ecki@zusammenkunft.net> wrote:

Is the following correct (I.e. it does not preserv free pages) and can
be added?

You are hung up on the idea of free pages when this operation makes them irrelevant.  Complete new files are written, populated to the extent of fill factor,  then the old files are removed.  At no point do empty pages get left over in the new file and they get treated the same as non-empty pages in the old file - they are utterly destroyed.


Sidenote how is the feeling about pointing to
non-included extension?

Not going to happen.

David J.

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

Предыдущее
От: "Bernd Eckenfels"
Дата:
Сообщение: Re: CLUSTER details
Следующее
От: "yanliang lei"
Дата:
Сообщение: Suggestion about tcp_keepalives_idle parameter in the document