Re: CLUSTER vs. VACUUM FULL - Mailing list pgsql-general

From Ron Johnson
Subject Re: CLUSTER vs. VACUUM FULL
Date
Msg-id CANzqJaCNn-Pd9Zyi4KvxbZ9qqR-ND9gUk1wgHKKYtxe0z7vh=w@mail.gmail.com
Whole thread Raw
In response to Re: CLUSTER vs. VACUUM FULL  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: CLUSTER vs. VACUUM FULL  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
On Mon, Apr 22, 2024 at 4:21 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
[snip] 
Which gets us back to your comment upstream:

"What the VACUUM docs "should" do, it seems, is suggest CLUSTER on the
PK, if the PK is a sequence (whether that be an actual sequence, or a
timestamp or something else that grows monotonically)."

This is a case specific to you and this particular circumstance, not a
general rule for VACUUM FULL. If for no other reason then it might make
more sense for the application that the CLUSTER be done on some other
index then the PK.

On Stack Exchange, I've got a question on how to determine when to run CLUSTER.  It ties in strongly with this thread..

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: issue with reading hostname
Next
From: Adrian Klaver
Date:
Subject: Re: CLUSTER vs. VACUUM FULL