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 <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1tTVP4-0069us-VP
	for pgsql-admin@arkaria.postgresql.org; Fri, 03 Jan 2025 00:19:03 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1tTVP4-003jFJ-AR
	for pgsql-admin@arkaria.postgresql.org; Fri, 03 Jan 2025 00:19:02 +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 <peter.m.gram@gmail.com>)
	id 1tTVP3-003jFA-VH
	for pgsql-admin@lists.postgresql.org; Fri, 03 Jan 2025 00:19:01 +0000
Received: from mail-yb1-xb2d.google.com ([2607:f8b0:4864:20::b2d])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <peter.m.gram@gmail.com>)
	id 1tTVP1-002uIm-3H
	for pgsql-admin@postgresql.org; Fri, 03 Jan 2025 00:19:01 +0000
Received: by mail-yb1-xb2d.google.com with SMTP id
 3f1490d57ef6-e46c6547266so14150078276.3
        for <pgsql-admin@postgresql.org>;
 Thu, 02 Jan 2025 16:18:59 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1735863538; x=1736468338;
 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=jCladk9G7n2NtQdtILmzhP2Djg8tDlG9opwKiOHNxqY=;
        b=kwy0ZMhIkIN0luimR7A+sKkqDL44dIVFD9y4SRtU1GbyCXoqe7Im0E3EQe38S7k3So
         eCrv0hprv4sV4j325+NuGZ6r/71UQnF1P06WjGwjUeqqfHTk4x5CKvLSSeAr2fNH+BxX
         WfxAgmTkhLFyiOEOUfHwQuRlaOhCz4VtiId2+Uovp75tcGLh2zBZma/K/7KbBmT/Nt74
         vJncwBhBsAaYunZ3sWUIjlvtfVSHIKmGKUSiRJUNX5z4JfZ8vQz2GvBZGFWd/SplGN0/
         CghjBgktXu6WRL8mlvXv/8xDuZcqYJn9p57hATkfbcEeoTeh7jW3yh3otlhC484+NFQk
         U04Q==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1735863538; x=1736468338;
        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=jCladk9G7n2NtQdtILmzhP2Djg8tDlG9opwKiOHNxqY=;
        b=NYY35fsAz2JY5JZIhf2VcxBm9XVrFg5gGoBSZ+LHduQgCuB4iLz1g+sxP0aSGMma6z
         ri+GHpw0aoJIVSOGCqP7nZXbu2hTWdFtQjh3zIklHKt1Gckfjp2jmwzGUxYwoo/nzOUm
         og/3rmV9sykJ++obYz17kMaWwTl1AsKU7D4hzTaCkPOMSkWyJkpsVl1q0oz51gFFIS/E
         dSRTXOTHPm0FAPIunB5rqCQHd3yA6yZOzdce7XjoPreP0su0seozKz0ts/95slE/8wuO
         a0TxVbodnuAsV5VdhHxmofdiSn+LwHx8dPBFlT9oIb134KO22HNsbknNR0NGoKFhlctA
         B2Gg==
X-Gm-Message-State: AOJu0YzkoHYAd5UF5TgAXq3FRK1ZL/sp462NtooUTD8NHxyOoTqrLpYl
	LxsZvHB3A/vbGuYtFlwHiKk3E4edNT+AMNLnMqVhJDPnChQS8ljTJTI54ek0X9kQ+s6rVzYT00/
	B2Lgv5M6xu90SxcWuA+Ntsw6bdrc=
X-Gm-Gg: ASbGnctWg9Y5GFTg3OE3Cele8qgdwQZmm8q9kbi9uj/y6/LJarxjIIIhmsZmcT0i1a6
	kTfM3iGCs229NqVhHvH/j4FGj4KURKWPjM8bwmLE=
X-Google-Smtp-Source: 
 AGHT+IFsr8kiL1kCw0VDUyWx/N3nlNAs4HdBbTZXPtm8TuZl//qO6c3MRWC0D+gYV2snkK2d450Eoq7peN/LfNTJdbs=
X-Received: by 2002:a05:690c:4807:b0:6f2:8db8:d546 with SMTP id
 00721157ae682-6f3f811b275mr282214707b3.11.1735863537887; Thu, 02 Jan 2025
 16:18:57 -0800 (PST)
MIME-Version: 1.0
References: 
 <CACReZzxJ0WfcJC9APM4so63aUP0JfpO0+SEHfeHu2i1vTmRB5A@mail.gmail.com>
 <CANzqJaBj=Js=nu==8PafL_Vk729_C+TixPgWm+7vSm8Qa1xS0Q@mail.gmail.com>
In-Reply-To: 
 <CANzqJaBj=Js=nu==8PafL_Vk729_C+TixPgWm+7vSm8Qa1xS0Q@mail.gmail.com>
From: Peter Gram <peter.m.gram@gmail.com>
Date: Fri, 3 Jan 2025 09:48:45 +0930
Message-ID: 
 <CAJ=80GU6HZE9XKc4vysXC21+Ou3svsN-q5_k12=fEL0_Up=6Dg@mail.gmail.com>
Subject: Re: Do we perform maintenance on pg_catalog tables
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000008df391062ac239c2"
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/CAJ%3D80GU6HZE9XKc4vysXC21%2BOu3svsN-q5_k12%3DfEL0_Up%3D6Dg%40mail.gmail.com>
Precedence: bulk

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

Hi Ron

How do I know if my AUTOVACUUM is Reasonably-tuned ?

Med venlig hilsen

Peter Gram
S=C3=A6byholmsvej 18
2500 Valby

Mobile: (+45) 5374 7107
Email: peter.m.gram@gmail.com



On Fri, 3 Jan 2025 at 06.45, Ron Johnson <ronljohnsonjr@gmail.com> wrote:

> On Thu, Jan 2, 2025 at 2:50=E2=80=AFPM srijith s <udbdoctor@gmail.com> wr=
ote:
>
>>
>> Hello PostgreSQL Experts,
>>
>> Do we perform postgres maintenance (vacuum/analyze/reindex) on pg_catalo=
g
>> tables?
>>
>
> Reasonably-tuned AUTOVACUUM config parameters should handle that for you.
>
> --
> Death to <Redacted>, and butter sauce.
> Don't boil me, I'm still alive.
> <Redacted> lobster!
>

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

<div dir=3D"auto">Hi Ron</div><div dir=3D"auto"><br></div><div dir=3D"auto"=
>How do I know if my=C2=A0<span style=3D"font-family:-apple-system,helvetic=
aneue">AUTOVACUUM is=C2=A0</span><span style=3D"font-family:-apple-system,h=
elveticaneue">Reasonably-tuned ?=C2=A0</span></div><div dir=3D"auto"><br cl=
ear=3D"all"><div dir=3D"auto"><div dir=3D"ltr" class=3D"gmail_signature" da=
ta-smartmail=3D"gmail_signature"><div dir=3D"ltr"><div><div dir=3D"ltr"><di=
v><div dir=3D"ltr"><div> Med venlig hilsen<br><br>Peter Gram<br>S=C3=A6byho=
lmsvej 18=C2=A0</div><div>2500 Valby <span style=3D"font-size:12.8px"></spa=
n><br><br></div><div>Mobile: (+45) 5374 7107<br></div><div>Email: <a href=
=3D"mailto:peter.m.gram@gmail.com" target=3D"_blank">peter.m.gram@gmail.com=
</a></div><div><div style=3D"color:rgb(34,34,34);font-family:arial,sans-ser=
if;font-size:small;font-style:normal;font-weight:400;letter-spacing:normal;=
text-align:start;text-indent:0px;text-transform:none;white-space:normal;wor=
d-spacing:0px;background-color:rgb(255,255,255)"><div><div dir=3D"ltr"><div=
><div dir=3D"ltr"><div><div dir=3D"ltr"><div dir=3D"ltr"><div><div><div><di=
v><br></div></div></div></div></div></div></div></div></div></div></div></d=
iv></div></div></div></div></div></div></div></div></div><div><br></div><di=
v><br><div class=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" cla=
ss=3D"gmail_attr">On Fri, 3 Jan 2025 at 06.45, Ron Johnson &lt;<a href=3D"m=
ailto:ronljohnsonjr@gmail.com">ronljohnsonjr@gmail.com</a>&gt; wrote:<br></=
div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-lef=
t:1px #ccc solid;padding-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr">On Thu=
, Jan 2, 2025 at 2:50=E2=80=AFPM srijith s &lt;<a href=3D"mailto:udbdoctor@=
gmail.com" target=3D"_blank">udbdoctor@gmail.com</a>&gt; wrote:</div><div c=
lass=3D"gmail_quote"><blockquote class=3D"gmail_quote" style=3D"margin:0px =
0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div=
 dir=3D"ltr"><div dir=3D"ltr"><div><br clear=3D"all"></div><div>Hello Postg=
reSQL Experts,</div><div><br></div><div>Do we perform postgres maintenance =
(vacuum/analyze/reindex) on pg_catalog tables?=C2=A0</div></div></div></blo=
ckquote><div><br></div><div></div></div><div>Reasonably-tuned AUTOVACUUM co=
nfig parameters should handle that for you.</div></div><div dir=3D"ltr"><di=
v><br></div><span class=3D"gmail_signature_prefix">-- </span><br><div dir=
=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr">Death to &lt;Redacted&g=
t;, and butter sauce.<div>Don&#39;t boil me, I&#39;m still alive.<br><div><=
div>&lt;Redacted&gt; lobster!</div></div></div></div></div></div>
</blockquote></div></div>

--0000000000008df391062ac239c2--