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

From: Demitri Muna <postgresql(at)demitri(dot)com>
To: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: CLUSTER, VACUUM, and TABLESPACEs (oh my)
Date: 2021-01-25 02:27:00
Message-ID: 7C25659B-FAD1-421E-8617-62793147FBE0@demitri.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> On Jan 24, 2021, at 9:03 PM, Guillaume Lelarge <guillaume(at)lelarge(dot)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, then VACUUM, will the existing order remain or be changed?

Demitri

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Stuart 2021-01-25 05:00:47 Can I use Postgres rules to reset session variables before/after queries?
Previous Message Guillaume Lelarge 2021-01-25 02:03:38 Re: CLUSTER, VACUUM, and TABLESPACEs (oh my)