Postgres Pro
Downloads
Home   >   mailing lists

Re: CLUSTER, VACUUM, and TABLESPACEs (oh my) - Mailing list pgsql-general

From Demitri Muna
Subject Re: CLUSTER, VACUUM, and TABLESPACEs (oh my)
Date
Msg-id 7C25659B-FAD1-421E-8617-62793147FBE0@demitri.com
Whole thread Raw
In response to Re: CLUSTER, VACUUM, and TABLESPACEs (oh my)  (Guillaume Lelarge <guillaume@lelarge.info>)
Responses Re: CLUSTER, VACUUM, and TABLESPACEs (oh my)
List pgsql-general
Tree view 
> On Jan 24, 2021, at 9:03 PM, Guillaume Lelarge <guillaume@lelarge.info> wrote:
>
>> 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).

Thank you for the clarification; that’s very helpful. For the case above. If I CLUSTER a table, add/delete no rows,
thenVACUUM, will the existing order remain or be changed? 

Demitri

pgsql-general by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: CLUSTER, VACUUM, and TABLESPACEs (oh my)
Next
From: Andrew Stuart
Date:
Subject: Can I use Postgres rules to reset session variables before/after queries?