Re: CLUSTER details - Mailing list pgsql-docs

From David G. Johnston
Subject Re: CLUSTER details
Date
Msg-id CAKFQuwbA+NYKBqOkBXDfDO19VBs-t-qsanoC+n6cYA3dRZH+Mg@mail.gmail.com
Whole thread Raw
In response to CLUSTER details  (PG Doc comments form <noreply@postgresql.org>)
Responses Re: CLUSTER details
List 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 by date:

Previous
From: "Bernd Eckenfels"
Date:
Subject: Re: CLUSTER details
Next
From: "yanliang lei"
Date:
Subject: Suggestion about tcp_keepalives_idle parameter in the document