MIME-Version: 1.0
References: <CANzqJaD8o0UuK42F==BXZA=L380n=aXt+VJ93PN3waFbNhZHBg@mail.gmail.com>
 <2870091.1713739514@sss.pgh.pa.us> <CANzqJaBvcGKdhqaZz+b0jNc8WLK74UCDW+zk=Ja78duOjWUBRA@mail.gmail.com>
 <CAApHDvraS7EkYZsgZnAWc-L4_jbie5UkPAtedKSqN6s1j+PJiQ@mail.gmail.com>
 <CAB-JLwYPrJpYGqsQFDpiMf6UFKeT1zwagabdb-2V3x0G8DqNPQ@mail.gmail.com>
 <3043219.1713795953@sss.pgh.pa.us> <CANzqJaDocQZNhD8CpGS7ae82tVeuL5-reoKy0_Y6=RKuTh6qwQ@mail.gmail.com>
 <CAKFQuwYFHCf+cd=wxJmzRqezQKy8rAKv2_QyvipzE1qboBXXvw@mail.gmail.com>
 <CANzqJaConAabzE942KSQV2BtZdBaEjvY9Cz_A8xvwrgauUX=zA@mail.gmail.com>
 <632e3176-13e4-4863-b8b9-bc1aba778268@aklaver.com> <CANzqJaDtterO9DEswkJOpgpizjLchYK7jOiJ0Pct0TEuc4Wv3g@mail.gmail.com>
 <4e81951f-4666-400d-b836-a020e55e168a@aklaver.com>
In-Reply-To: <4e81951f-4666-400d-b836-a020e55e168a@aklaver.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Mon, 22 Apr 2024 16:59:44 -0400
Message-ID: <CANzqJaCNn-Pd9Zyi4KvxbZ9qqR-ND9gUk1wgHKKYtxe0z7vh=w@mail.gmail.com>
Subject: Re: CLUSTER vs. VACUUM FULL
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000003566380616b5b881"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaCNn-Pd9Zyi4KvxbZ9qqR-ND9gUk1wgHKKYtxe0z7vh%3Dw%40mail.gmail.com>
Precedence: bulk

--0000000000003566380616b5b881
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Mon, Apr 22, 2024 at 4:21=E2=80=AFPM Adrian Klaver <adrian.klaver@aklave=
r.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..

--0000000000003566380616b5b881
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Mon, Apr 22, 2024 at 4:21=E2=80=AFPM A=
drian Klaver &lt;<a href=3D"mailto:adrian.klaver@aklaver.com">adrian.klaver=
@aklaver.com</a>&gt; wrote:<br></div><div class=3D"gmail_quote"><div>[snip]=
=C2=A0</div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0=
.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Which gets us=
 back to your comment upstream:<br>
<br>
&quot;What the VACUUM docs &quot;should&quot; do, it seems, is suggest CLUS=
TER on the <br>
PK, if the PK is a sequence (whether that be an actual sequence, or a <br>
timestamp or something else that grows monotonically).&quot;<br>
<br>
This is a case specific to you and this particular circumstance, not a <br>
general rule for VACUUM FULL. If for no other reason then it might make <br=
>
more sense for the application that the CLUSTER be done on some other <br>
index then the PK.<br></blockquote><div><br></div><div>On Stack Exchange, I=
&#39;ve got a question on how to determine when to run CLUSTER.=C2=A0 It ti=
es in strongly with this thread..</div><div><br></div></div></div>

--0000000000003566380616b5b881--