Re: CLUSTER details - Mailing list pgsql-docs

From David G. Johnston
Subject Re: CLUSTER details
Date
Msg-id CAKFQuwYt3UaSa8YjDSVvU=aKtoXvcORBZrQi0Rd1aTbUg+PxUg@mail.gmail.com
Whole thread Raw
In response to Re: CLUSTER details  ("Bernd Eckenfels" <ecki@zusammenkunft.net>)
List pgsql-docs
On Friday, June 7, 2024, Bernd Eckenfels <ecki@zusammenkunft.net> wrote:

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.

Yeah, it doesn’t make it clear that rewriting the table means that only live tuples are written into the new file and thus there is a size difference before and after equal to the dead tuples not written.

David J.
 

pgsql-docs by date:

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