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(at)zusammenkunft(dot)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