MIME-Version: 1.0
References: <CAJCZkoJF-97BatLoVf1SUBTAX8BrSeX0dgZS+tBOM2imNnGRFQ@mail.gmail.com>
 <CANzqJaCoH2My0YU9cKDDAtSx5vsTyXcpVH9y7WxZCddNmRPU8w@mail.gmail.com>
 <CAJCZkoK-ipKCuiLuc=S=nrNVCPnbsKAUOs6cS9=1kdftcBQFPw@mail.gmail.com>
 <CANzqJaAO4AbdceTA=4bmSA4sCG6viP28hDeeYjYOUe=jzLVbmg@mail.gmail.com>
 <CAJCZkoLc=YXc4H2-aGbp2e-R+WsaLRxiAoj2acLP4=A7z+7xAg@mail.gmail.com>
 <CANzqJaCMWyPCcYhp0fd0=jatpcExFNsJ6=Gz8ZxEeUHGE-h+MQ@mail.gmail.com>
 <CAJCZkoK_JMcjawyCAGSo8gc8sHad7ugFLZzjuqP2Jmkn_G=Ecw@mail.gmail.com> <879d7275-836b-430d-bdd0-bbb8b92d3320@aklaver.com>
In-Reply-To: <879d7275-836b-430d-bdd0-bbb8b92d3320@aklaver.com>
From: Durgamahesh Manne <maheshpostgres9@gmail.com>
Date: Wed, 11 Feb 2026 08:11:36 +0530
Message-ID: <CAJCZkoLnmJqYcM5bSmhGnBfbGpqQ9A7BDmyti49DQ7TeeQxxDg@mail.gmail.com>
Subject: Re: Table bloat threshold limit to trigger repack
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: Ron Johnson <ronljohnsonjr@gmail.com>, pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000003b2e32064a8350e0"
Archived-At: <https://www.postgresql.org/message-id/CAJCZkoLnmJqYcM5bSmhGnBfbGpqQ9A7BDmyti49DQ7TeeQxxDg%40mail.gmail.com>
Precedence: bulk

--0000000000003b2e32064a8350e0
Content-Type: text/plain; charset="UTF-8"

On Mon, 9 Feb, 2026, 02:16 Adrian Klaver, <adrian.klaver@aklaver.com> wrote:

> On 2/8/26 10:05, Durgamahesh Manne wrote:
> >
>
> > Any recommendations are welcome
> > Please find attached ss
> >
>
> FYI, you can copy and paste from a terminal session in Windows.
>
> Just select the text with the mouse and hit Enter, then Ctl+V to paste
> it somewhere else.
>
> Text in an email is easier to work with if someone wants to set up a
> test case on their machine.
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com


Hi @Adrian Klaver <adrian.klaver@aklaver.com>

In this case autovacuum triggers for every 1hour on toast table

Access method: heap Options: fillfactor=80,
autovacuum_vacuum_cost_limit=2000, autovacuum_vacuum_cost_delay=10,
autovacuum_enabled=true, autovacuum_vacuum_scale_factor=0.1,
autovacuum_vacuum_threshold=100000, autovacuum_analyze_threshold=20000,
toast.autovacuum_enabled=true, toast.autovacuum_vacuum_scale_factor=0.1,
toast.autovacuum_vacuum_cost_limit=3000,
toast.autovacuum_vacuum_threshold=400000


Please let me know if any recommendations
And need to increase speed of autovacuum execution time which takes 5min to
complete
Ram 128gb
Cpu 32

Autovacuum work mem 6gb assigned
Buffer usage limit?
Regards
Durga Mahesh

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

<div dir=3D"auto"><div><br><br><div class=3D"gmail_quote gmail_quote_contai=
ner"><div dir=3D"ltr" class=3D"gmail_attr">On Mon, 9 Feb, 2026, 02:16 Adria=
n Klaver, &lt;<a href=3D"mailto:adrian.klaver@aklaver.com">adrian.klaver@ak=
laver.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=
=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">On 2/8/2=
6 10:05, Durgamahesh Manne wrote:<br>
&gt; <br>
<br>
&gt; Any recommendations are welcome<br>
&gt; Please find attached ss<br>
&gt; <br>
<br>
FYI, you can copy and paste from a terminal session in Windows.<br>
<br>
Just select the text with the mouse and hit Enter, then Ctl+V to paste <br>
it somewhere else.<br>
<br>
Text in an email is easier to work with if someone wants to set up a <br>
test case on their machine.<br>
<br>
<br>
-- <br>
Adrian Klaver<br>
<a href=3D"mailto:adrian.klaver@aklaver.com" target=3D"_blank" rel=3D"noref=
errer">adrian.klaver@aklaver.com</a></blockquote></div></div><div dir=3D"au=
to"><br></div><div dir=3D"auto">Hi <span class=3D"gmail_chip gmail_plusrepl=
y" dir=3D"auto"><a href=3D"mailto:adrian.klaver@aklaver.com" style=3D"color=
:#15c;text-decoration:underline">@Adrian Klaver</a></span><span>=C2=A0</spa=
n></div><div dir=3D"auto"><span><br></span></div><div dir=3D"auto"><span>In=
 this case autovacuum triggers for every 1hour on toast table=C2=A0</span><=
/div><div dir=3D"auto"><span><br></span></div><div dir=3D"auto"><span>Acces=
s method: heap Options: fillfactor=3D80, autovacuum_vacuum_cost_limit=3D200=
0, autovacuum_vacuum_cost_delay=3D10, autovacuum_enabled=3Dtrue, autovacuum=
_vacuum_scale_factor=3D0.1, autovacuum_vacuum_threshold=3D100000, autovacuu=
m_analyze_threshold=3D20000, toast.autovacuum_enabled=3Dtrue, toast.autovac=
uum_vacuum_scale_factor=3D0.1, toast.autovacuum_vacuum_cost_limit=3D3000, t=
oast.autovacuum_vacuum_threshold=3D400000</span></div><div dir=3D"auto"><sp=
an><br></span></div><div dir=3D"auto"><span><br></span></div><div dir=3D"au=
to"><span>Please let me know if any recommendations</span></div><div dir=3D=
"auto">And need to increase speed of autovacuum execution time which takes =
5min to complete=C2=A0</div><div dir=3D"auto">Ram 128gb</div><div dir=3D"au=
to">Cpu 32</div><div dir=3D"auto"><br></div><div dir=3D"auto">Autovacuum wo=
rk mem 6gb assigned=C2=A0</div><div dir=3D"auto">Buffer usage limit?</div><=
div dir=3D"auto"><span>Regards</span></div><div dir=3D"auto"><span>Durga Ma=
hesh</span></div><div dir=3D"auto"></div></div>

--0000000000003b2e32064a8350e0--