Re: CLUSTER, VACUUM, and TABLESPACEs (oh my)

Guillaume Lelarge <guillaume@xxxxxxxxxxxx> · Mon, 25 Jan 2021 03:03:38 +0100

Le lun. 25 janv. 2021 à 02:54, Ron <ronljohnsonjr@xxxxxxxxx> a écrit :

    On 1/24/21 7:50 PM, Guillaume Lelarge wrote:

        Hi,

          Le lun. 25 janv. 2021 à
            01:38, Demitri Muna <postgresql@xxxxxxxxxxx> a
            écrit :

    [snip]

            * If I have previously run a CLUSTER command on a table,
            will future VACUUM FULL commands rewrite the table in the
            order specified in the previous CLUSTER?

        No, you still need CLUSTER.

    VACUUM FULL unclusters the table??

It will rebuild the table without sorting the data according to the index used with CLUSTER (without any sorting actually).