Subject: Re: CLUSTER details
To: pgsql-docs@lists.postgresql.org
References: <171773198715.20945.13194211966251728461@wrigleys.postgresql.org>
 <CAKFQuwZp2sfBHiK9tr_UCFu4OaJEvrRpCd=N1ugTzDwCR79xEQ@mail.gmail.com>
 <20240607175709.4A4FB663856@dd33810.kasserver.com><CAKFQuwbA+NYKBqOkBXDfDO19VBs-t-qsanoC+n6cYA3dRZH+Mg@mail.gmail.com>
From: "Bernd Eckenfels" <ecki@zusammenkunft.net>
User-Agent: ALL-INKL Webmail 2.11 mobile
MIME-Version: 1.0
In-Reply-To: 
 <CAKFQuwbA+NYKBqOkBXDfDO19VBs-t-qsanoC+n6cYA3dRZH+Mg@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Message-Id: <20240608024339.9FC00660035@dd33810.kasserver.com>
Date: Sat,  8 Jun 2024 04:43:39 +0200 (CEST)
Archived-At: 
 <https://www.postgresql.org/message-id/20240608024339.9FC00660035%40dd33810.kasserver.com>
Precedence: bulk

I am mostly „hung up“ on extending the doc to make it even more
usedul (by sharing my use cases).

As a user I want to know if CLUSTERing also frees space, and since it
has the effect of doing so (and not pre-allocates, which is a bit odd),why
not mention it.

Btw where is that friendly community the Internet brags about?

Gruss
Bernd

David G. Johnston wrote on 7. June 2024 20:44 (GMT +02:00):

> 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.
> 


Gruß
Bernd
— 
https://bernd.eckenfels.net