Postgres Pro
Downloads
Home   >   mailing lists

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

From Guillaume Lelarge
Subject Re: CLUSTER, VACUUM, and TABLESPACEs (oh my)
Date
Msg-id CAECtzeXdWYR4ps1o0h=ga6y7_FWTuooz2OKS0OXKqEUVOCr+PA@mail.gmail.com
Whole thread Raw
In response to Re: CLUSTER, VACUUM, and TABLESPACEs (oh my)  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: CLUSTER, VACUUM, and TABLESPACEs (oh my)
List pgsql-general
Tree view
Le lun. 25 janv. 2021 à 02:54, Ron <ronljohnsonjr@gmail.com> a écrit :
On 1/24/21 7:50 PM, Guillaume Lelarge wrote:
Hi,

Le lun. 25 janv. 2021 à 01:38, Demitri Muna <postgresql@demitri.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).

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: CLUSTER, VACUUM, and TABLESPACEs (oh my)
Next
From: Demitri Muna
Date:
Subject: Re: CLUSTER, VACUUM, and TABLESPACEs (oh my)