Re: CLUSTER details - Mailing list pgsql-docs

From Bernd Eckenfels
Subject Re: CLUSTER details
Date
Msg-id 20240608024339.9FC00660035@dd33810.kasserver.com
Whole thread Raw
In response to Re: CLUSTER details  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: CLUSTER details
List pgsql-docs
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



pgsql-docs by date:

Previous
From: "yanliang lei"
Date:
Subject: Suggestion about tcp_keepalives_idle parameter in the document
Next
From: "Euler Taveira"
Date:
Subject: Re: DROP TRIGGER lock