On Sun, Apr 21, 2024 at 6:45 PM Tom Lane <t...@sss.pgh.pa.us> wrote:
> Ron Johnson <ronljohnso...@gmail.com> writes: > > Why is VACUUM FULL recommended for compressing a table, when CLUSTER does > > the same thing (similarly doubling disk space), and apparently runs just > as > > fast? > > CLUSTER makes the additional effort to sort the data per the ordering > of the specified index. I'm surprised that's not noticeable in your > test case. > Clustering on a completely different index was also 44 seconds.