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 1rz1oS-001Zt1-CP for pgsql-general@arkaria.postgresql.org; Mon, 22 Apr 2024 22:07:00 +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 1rz1oO-000zkU-Un for pgsql-general@arkaria.postgresql.org; Mon, 22 Apr 2024 22:06:56 +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 1rz1oO-000ziN-GZ for pgsql-general@lists.postgresql.org; Mon, 22 Apr 2024 22:06:56 +0000 Received: from mail-ot1-x336.google.com ([2607:f8b0:4864:20::336]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rz1oM-002Plo-68 for pgsql-general@postgresql.org; Mon, 22 Apr 2024 22:06:55 +0000 Received: by mail-ot1-x336.google.com with SMTP id 46e09a7af769-6eb7d1a5d39so2924016a34.2 for ; Mon, 22 Apr 2024 15:06:53 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1713823612; x=1714428412; darn=postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=lIvcs/OdVURRr3QlEzGRc8UQUlUEH+eVVz5R4nX1M8Q=; b=VoEpSiN+X2dj9+aYbw+dExFOMAjQ6KZkBQEaPkj1lxvf2hD536DuZggeHiMpJYYMvL m7lBTO34TyO/Gst1pqJZdsznEgcEElgFFN8Or/pt+sBsgE65hsAlSOt+K22T6+bL7vOs X1GRXH2U3HrXblSUl18EaV7L1tjDJNiWI8ghFKVQR8FdbJxnjZZRSsJXliYFu69/zUVT 6Pcv5t+qQMObINej9MQM+kC4y9uU6XxGdmVY5KmVucOucoEkXcb5t4ga82Ljr+qqERAK H/Pck8+0cYmFZIE10/nudXWjChlo+ihSFila6cmyG+P4XD4jf6C3b2ZZsOp5RR7DqZgP xD7g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1713823612; x=1714428412; h=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=lIvcs/OdVURRr3QlEzGRc8UQUlUEH+eVVz5R4nX1M8Q=; b=Zni3CNpC01yzBAPaWHWBNkIYRF/hVoYc2DQ3UOrVe6v1b2Qv0JmHq6PIPEXBOAzpOU ZvKRq+uO2CW68AJ677DujPJ/UN9SLwc33jSg0hOTTaecpyrEGnC1z/dbY4xj8sGNwvrz OyUrmVJxQg6ZK7L6eV087vxMGhSKyD9T3EpsaBeqdxXafQTSMP/B9blh3K7r5vvS/Kzo jQbTHFrMJWID28qGB+jUMN5AEnlON7XVIRlSCRi36TEPny/EoPYVpxM/yrsjWuZL/NCV w9hn000CvYOh73vmtHbG/FCL2+N1I3LFzfJRabiBjQb8L2p6nfXb+T9hN3uhycxcNkuA c3aQ== X-Gm-Message-State: AOJu0YyBHrj1SxR69dJAUmcDB6FPfgOzn9VdYLN8WVAZ6OB8NcpYd7O5 vYC7gx6q+nPilGe0D1DpHccvXRUygU5a3kzU1pg4BWXsIh0Zpm0D/y21Yd5jmIkMq0hcyuRqQLk NGzM0Iu5lC7b025zV9nn0qjEnCzFo5A== X-Google-Smtp-Source: AGHT+IEDZp1QKIutSxST0kNtTHB/Bpz/ifc1RoPyTn/4BVHI95JhF6APdHfgf76r/anMQN0YAhsfTPVyHSkq+/NnB5g= X-Received: by 2002:a05:6870:b013:b0:238:f752:b1f with SMTP id y19-20020a056870b01300b00238f7520b1fmr12792800oae.59.1713823611899; Mon, 22 Apr 2024 15:06:51 -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> <26cf1d8d-42c9-447a-b353-ff01de8f68f2@aklaver.com> In-Reply-To: <26cf1d8d-42c9-447a-b353-ff01de8f68f2@aklaver.com> From: Ron Johnson Date: Mon, 22 Apr 2024 18:06:40 -0400 Message-ID: Subject: Re: CLUSTER vs. VACUUM FULL To: pgsql-general Content-Type: multipart/alternative; boundary="0000000000009857660616b6a7bf" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000009857660616b6a7bf Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Mon, Apr 22, 2024 at 5:56=E2=80=AFPM Adrian Klaver wrote: > On 4/22/24 14:35, Ron Johnson wrote: > > > > > > > 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? > > It should have been the initial question of this thread and it explains > what you are really after. > It was already a long email. --0000000000009857660616b6a7bf Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Mon, Apr 22, 2024 at 5:56=E2=80=AFPM A= drian Klaver <adrian.klaver= @aklaver.com> wrote:
On 4/22/24 14:35, Ron Johnson wrote:=

>=C2=A0 =C2=A0 =C2=A0 >
>=C2=A0 =C2=A0 =C2=A0 > On Stack Exchange, I've got a question on= how to determine when
>=C2=A0 =C2=A0 =C2=A0to run
>=C2=A0 =C2=A0 =C2=A0 > CLUSTER.=C2=A0 It ties in strongly with this = thread..
>=C2=A0 =C2=A0 =C2=A0 >
>
>=C2=A0 =C2=A0 =C2=A0And the link is?

It should have been the initial question of this thread and it explains what you are really after.

It was alrea= dy a long email.=C2=A0
--0000000000009857660616b6a7bf--