MIME-Version: 1.0
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Thu, 7 Nov 2024 10:30:40 -0500
Message-ID: 
 <CANzqJaDh3vYp2dej87Oq=gOTrQS-3C9kOPgGgTeEQa7ku9bRDA@mail.gmail.com>
Subject: number of updated or deleted tuples needed to trigger a VACUUM in any
 one table
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000cd233306265451f1"
Archived-At: 
 <https://www.postgresql.org/message-id/CANzqJaDh3vYp2dej87Oq%3DgOTrQS-3C9kOPgGgTeEQa7ku9bRDA%40mail.gmail.com>
Precedence: bulk

--000000000000cd233306265451f1
Content-Type: text/plain; charset="UTF-8"

https://www.postgresql.org/docs/current/runtime-config-autovacuum.html

autovacuum_vacuum_threshold (integer)
<https://www.postgresql.org/docs/current/runtime-config-autovacuum.html#GUC-AUTOVACUUM-VACUUM-THRESHOLD>

Specifies the minimum number of updated or deleted tuples needed to trigger
a VACUUM in any one table.

Are the number of updated and deleted tuples since the last vacuum exposed
anywhere, like n_ins_since_vacuum is exposed?

I've Googled with no luck.

-- 
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

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

<div dir=3D"ltr"><div><br clear=3D"all"></div><div><a href=3D"https://www.p=
ostgresql.org/docs/current/runtime-config-autovacuum.html">https://www.post=
gresql.org/docs/current/runtime-config-autovacuum.html</a><br></div><div><b=
r></div><div><dt id=3D"gmail-GUC-AUTOVACUUM-VACUUM-THRESHOLD" style=3D"box-=
sizing:border-box;font-family:monospace;color:rgb(0,0,0);font-size:14.4px">=
<span class=3D"gmail-term" style=3D"box-sizing:border-box"><code class=3D"g=
mail-varname" style=3D"box-sizing:border-box;font-family:monospace,monospac=
e;font-size:1em;border-radius:0.25rem;margin:0.6rem 0px">autovacuum_vacuum_=
threshold</code>=C2=A0(<code class=3D"gmail-type" style=3D"box-sizing:borde=
r-box;font-family:monospace,monospace;font-size:1em;border-radius:0.25rem;m=
argin:0.6rem 0px">integer</code>)=C2=A0<a id=3D"gmail-id-1.6.6.13.4.4.1.3" =
class=3D"gmail-indexterm" name=3D"id-1.6.6.13.4.4.1.3" style=3D"box-sizing:=
border-box;background-color:transparent;font-weight:600"></a></span><a href=
=3D"https://www.postgresql.org/docs/current/runtime-config-autovacuum.html#=
GUC-AUTOVACUUM-VACUUM-THRESHOLD" class=3D"gmail-id_link" style=3D"box-sizin=
g:border-box;color:inherit;text-decoration-line:none;background-color:trans=
parent;font-weight:600"></a></dt><dd style=3D"box-sizing:border-box;margin-=
bottom:0.5rem;margin-left:0px;margin-top:1rem;color:rgb(0,0,0);font-family:=
&quot;Open Sans&quot;,sans-serif;font-size:14.4px"><p style=3D"box-sizing:b=
order-box;margin:1rem 0px 1rem 2rem">Specifies the minimum number of update=
d or deleted tuples needed to trigger a=C2=A0<code class=3D"gmail-command" =
style=3D"box-sizing:border-box;font-family:monospace,monospace;font-size:1e=
m;border-radius:0.25rem;margin:0.6rem 0px">VACUUM</code>=C2=A0in any one ta=
ble.</p></dd></div><div><br></div><div>Are the number of updated and delete=
d tuples since the last vacuum exposed anywhere,=C2=A0like=C2=A0<span style=
=3D"color:rgb(33,37,41);font-family:monospace,monospace;font-size:14.4px">n=
_ins_since_vacuum</span>=C2=A0is exposed?</div><div><br></div><div>I&#39;ve=
 Googled with no luck.</div><div><br></div><span class=3D"gmail_signature_p=
refix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature" data-smartm=
ail=3D"gmail_signature"><div dir=3D"ltr">Death to &lt;Redacted&gt;, and but=
ter sauce.<div>Don&#39;t boil me, I&#39;m still alive.<br><div><div>&lt;Red=
acted&gt; lobster!</div></div></div></div></div></div>

--000000000000cd233306265451f1--