Re: CLUSTER details

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