Postgres Pro
Downloads
Home   >   mailing lists

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

From Ron
Subject Re: CLUSTER, VACUUM, and TABLESPACEs (oh my)
Date
Msg-id 418a37cf-df5b-2264-784c-009d38cddbde@gmail.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 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??

--
Angular momentum makes the world go 'round.

pgsql-general by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: CLUSTER, VACUUM, and TABLESPACEs (oh my)
Next
From: Guillaume Lelarge
Date:
Subject: Re: CLUSTER, VACUUM, and TABLESPACEs (oh my)