Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rz1Kl-001Xkx-5B for pgsql-general@arkaria.postgresql.org; Mon, 22 Apr 2024 21:36:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rz1Kj-00HYYm-Qy for pgsql-general@arkaria.postgresql.org; Mon, 22 Apr 2024 21:36:17 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rz1Kj-00HYYa-FP for pgsql-general@lists.postgresql.org; Mon, 22 Apr 2024 21:36:17 +0000 Received: from mail-oa1-x29.google.com ([2001:4860:4864:20::29]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rz1Kc-002PXa-Dy for pgsql-general@postgresql.org; Mon, 22 Apr 2024 21:36:16 +0000 Received: by mail-oa1-x29.google.com with SMTP id 586e51a60fabf-23a6a8e9978so501033fac.3 for ; Mon, 22 Apr 2024 14:36:10 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1713821768; x=1714426568; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=WMcx9I/BP/tESi1MhQZQWt3fSnJxFT7NHYColkDNV2k=; b=JQWRyzMF0ZcDbdjM1+nKkoswQabPq5sSQOHOhcGnOSp8C/5qvGUoaXmQ444v9Do7jO 7wuLqB6iloqKfVmxhCGbrBE3tzqrGSzxbXfoTLgp9OPSA+O0oySvb+T++snMD2qC1Nm4 vuvPcCTdrAeTHlDW2qILeV2YvxfkBZZpNeqGaq//16Evc8JFW5w7Ut+VOhUPcmkFxxDJ pmwd+CxlAvUFAgDHIyN9TrzdjUukPqq0LMF+j7u8XE1eJ5QUJrExsTtdh7o+sfMFuu0K NPslDcnub9ZYQZcWTc45cC97TaO4HmoG2G+bxQf/j0J2Sd9zvWinEjJartZyCBy/Gimb 5ZDA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1713821768; x=1714426568; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=WMcx9I/BP/tESi1MhQZQWt3fSnJxFT7NHYColkDNV2k=; b=PEZZWwokA6vIFB/yOOg7yIXH19tyWeUNTWcc0Mw7ozr6AMB5BlsMomk4DEaY4+k/Nj yr+3S5oTR89zBNxXzobgQfXtB+WGaPfhnDa43bUrQsSA4Dpei2kK1+0v1A3DBFY92jmc DsqV2KSq06IAazDg0ha/YDjo2AIN4tiPqTaoFSt7aSObs+rB1TYwyXitwwgBhDcDay+N i3bHk1Rd4piydgtBX5vbA+xz0YaGK9AxQ3XhY5ghXfrgHJSTxirZXb5tXzO0QMFbvYBK DgXWO0kUsh3QPZQ62MM03vbNeJXoadYozqCA7oN8PKG1x6Kpbz0NtzAPSx6q5auBuJ2p g6AQ== X-Gm-Message-State: AOJu0YzJ59A+DVgQEhaDsd0C1EzVW4lAqe3bQcFtw1cGF/t08qvdaHrF IDbTvyORQeFsQA5WmNFjBwUJKU5Umop1kUo/cL3FabI5QCscn1wHwv8tVk8DBO1NCARW3fBkwt/ 1Rr02h6YmljLVkoftJOT90x5R9zU= X-Google-Smtp-Source: AGHT+IFZpVKDO6a9DGaPEosRmIUbGtcNZYN90ZqxAtsy15sCYFEaCxMOycAsYmJ8cmlYa2ubFUiKQYTG2Wv/B0QRG+I= X-Received: by 2002:a05:6870:7184:b0:239:7f90:e54 with SMTP id d4-20020a056870718400b002397f900e54mr14270135oah.18.1713821768329; Mon, 22 Apr 2024 14:36:08 -0700 (PDT) MIME-Version: 1.0 References: <2870091.1713739514@sss.pgh.pa.us> <3043219.1713795953@sss.pgh.pa.us> <632e3176-13e4-4863-b8b9-bc1aba778268@aklaver.com> <4e81951f-4666-400d-b836-a020e55e168a@aklaver.com> In-Reply-To: From: Ron Johnson Date: Mon, 22 Apr 2024 17:35:57 -0400 Message-ID: Subject: Re: CLUSTER vs. VACUUM FULL To: Adrian Klaver Cc: pgsql-general Content-Type: multipart/alternative; boundary="000000000000b5b0720616b639bd" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000b5b0720616b639bd Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Mon, Apr 22, 2024 at 5:03=E2=80=AFPM Adrian Klaver wrote: > On 4/22/24 13:59, Ron Johnson wrote: > > On Mon, Apr 22, 2024 at 4:21=E2=80=AFPM Adrian Klaver > > 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, no= t > 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 oth= er > > 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.. > > > > And the link is? > Sorry. Got distracted by the answer. https://dba.stackexchange.com/questions/338870/when-to-rerun-cluster --000000000000b5b0720616b639bd Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Mon, Apr 22, 2024 at 5:03=E2=80=AFPM A= drian Klaver <adrian.klaver= @aklaver.com> wrote:
On 4/22/24 13:59, Ron Johnson wrote:=
> On Mon, Apr 22, 2024 at 4:21=E2=80=AFPM Adrian Klaver <adrian.klaver@aklaver.co= m
> <mailto:adrian.klaver@aklaver.com>> wrote:
> [snip]
>
>=C2=A0 =C2=A0 =C2=A0Which gets us back to your comment upstream:
>
>=C2=A0 =C2=A0 =C2=A0"What the VACUUM docs "should" do, i= t seems, is suggest CLUSTER on the
>=C2=A0 =C2=A0 =C2=A0PK, if the PK is a sequence (whether that be an act= ual sequence, or a
>=C2=A0 =C2=A0 =C2=A0timestamp or something else that grows monotonicall= y)."
>
>=C2=A0 =C2=A0 =C2=A0This is a case specific to you and this particular = circumstance, not a
>=C2=A0 =C2=A0 =C2=A0general rule for VACUUM FULL. If for no other reaso= n then it might make
>=C2=A0 =C2=A0 =C2=A0more sense for the application that the CLUSTER be = done on some other
>=C2=A0 =C2=A0 =C2=A0index then the PK.
>
>
> On Stack Exchange, I've got a question on how to determine when to= run
> CLUSTER.=C2=A0 It ties in strongly with this thread..
>

And the link is?

Sorry.=C2=A0 Got distr= acted by the answer.

=C2=A0
=C2=A0
--000000000000b5b0720616b639bd--