From: Bernd Eckenfels <ecki@zusammenkunft.net>
To: pgsql-docs@lists.postgresql.org
Subject: Re: CLUSTER details
Date: Sat, 8 Jun 2024 04:43:39 +0200 (CEST)
Message-ID: <20240608024339.9FC00660035@dd33810.kasserver.com> (raw)
In-Reply-To: <CAKFQuwbA+NYKBqOkBXDfDO19VBs-t-qsanoC+n6cYA3dRZH+Mg@mail.gmail.com>
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>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: ecki@zusammenkunft.net, pgsql-docs@lists.postgresql.org
Subject: Re: CLUSTER details
In-Reply-To: <20240608024339.9FC00660035@dd33810.kasserver.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox