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.