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

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Ron <ronljohnsonjr(at)gmail(dot)com>
Cc: "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:03:38
Message-ID: CAECtzeXdWYR4ps1o0h=ga6y7_FWTuooz2OKS0OXKqEUVOCr+PA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Le lun. 25 janv. 2021 à 02:54, Ron <ronljohnsonjr(at)gmail(dot)com> a écrit :

> On 1/24/21 7:50 PM, Guillaume Lelarge wrote:
>
> Hi,
>
> Le lun. 25 janv. 2021 à 01:38, Demitri Muna <postgresql(at)demitri(dot)com> 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).

>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Demitri Muna 2021-01-25 02:27:00 Re: CLUSTER, VACUUM, and TABLESPACEs (oh my)
Previous Message Ron 2021-01-25 01:53:55 Re: CLUSTER, VACUUM, and TABLESPACEs (oh my)