MIME-Version: 1.0
References: <CAJCZkoJF-97BatLoVf1SUBTAX8BrSeX0dgZS+tBOM2imNnGRFQ@mail.gmail.com>
 <CANzqJaCoH2My0YU9cKDDAtSx5vsTyXcpVH9y7WxZCddNmRPU8w@mail.gmail.com>
In-Reply-To: <CANzqJaCoH2My0YU9cKDDAtSx5vsTyXcpVH9y7WxZCddNmRPU8w@mail.gmail.com>
From: Durgamahesh Manne <maheshpostgres9@gmail.com>
Date: Sun, 8 Feb 2026 11:13:07 +0530
Message-ID: <CAJCZkoK-ipKCuiLuc=S=nrNVCPnbsKAUOs6cS9=1kdftcBQFPw@mail.gmail.com>
Subject: Re: Table bloat threshold limit to trigger repack
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000e1d12e064a497f0f"
Archived-At: <https://www.postgresql.org/message-id/CAJCZkoK-ipKCuiLuc%3DS%3DnrNVCPnbsKAUOs6cS9%3D1kdftcBQFPw%40mail.gmail.com>
Precedence: bulk

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

On Sun, 8 Feb, 2026, 10:59 Ron Johnson, <ronljohnsonjr@gmail.com> wrote:

> On Sat, Feb 7, 2026 at 11:19=E2=80=AFPM Durgamahesh Manne <
> maheshpostgres9@gmail.com> wrote:
>
>> Hi
>>
>> How much table bloat is acceptable before it affects performance in
>> PostgreSQL?
>>
>
> How big is the table? (For small tables, it doesn't matter.) How active i=
s
> it?  How frequently are records updated?
>
> --
> Death to <Redacted>, and butter sauce.
> Don't boil me, I'm still alive.
> <Redacted> lobster!
>


Hi

Table size 100gb
I use pgstattuple_approx to get Table bloat is about 16gb as of now since
after repack is done on 27th of January
Fillfactor already in place
It's very critical application with updates on non partitioned table

Regards
Durga Mahesh

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

<div dir=3D"auto"><div><br><br><br><div class=3D"gmail_quote gmail_quote_co=
ntainer"><div dir=3D"ltr" class=3D"gmail_attr">On Sun, 8 Feb, 2026, 10:59 R=
on Johnson, &lt;<a href=3D"mailto:ronljohnsonjr@gmail.com">ronljohnsonjr@gm=
ail.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"><div dir=3D"=
ltr"><div dir=3D"ltr">On Sat, Feb 7, 2026 at 11:19=E2=80=AFPM Durgamahesh M=
anne &lt;<a href=3D"mailto:maheshpostgres9@gmail.com" target=3D"_blank" rel=
=3D"noreferrer">maheshpostgres9@gmail.com</a>&gt; wrote:</div><div class=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=
"auto">Hi<div dir=3D"auto"><br></div><div dir=3D"auto">How much table bloat=
 is acceptable before it affects performance in PostgreSQL?=C2=A0<br></div>=
</div></blockquote><div><br></div><div>How big is the table? (For small tab=
les, it doesn&#39;t matter.) How active is it?=C2=A0 How frequently are rec=
ords updated?</div><div><br></div><div>--</div></div><div dir=3D"ltr" class=
=3D"gmail_signature"><div dir=3D"ltr">Death to &lt;Redacted&gt;, and butter=
 sauce.<div>Don&#39;t boil me, I&#39;m still alive.<br><div><div>&lt;Redact=
ed&gt; lobster!</div></div></div></div></div></div></blockquote></div></div=
><div dir=3D"auto"><br></div><div dir=3D"auto"><br></div><div dir=3D"auto">=
Hi</div><div dir=3D"auto"><br></div><div dir=3D"auto">Table size 100gb</div=
><div dir=3D"auto">I use pgstattuple_approx to get Table bloat is about 16g=
b as of now since after repack is done on 27th of January=C2=A0</div><div d=
ir=3D"auto">Fillfactor already in place</div><div dir=3D"auto">It&#39;s ver=
y critical application with updates on non partitioned table=C2=A0</div><di=
v dir=3D"auto"><br></div><div dir=3D"auto">Regards=C2=A0</div><div dir=3D"a=
uto">Durga Mahesh=C2=A0</div><div dir=3D"auto"><br></div><div dir=3D"auto">=
<div class=3D"gmail_quote gmail_quote_container"><blockquote class=3D"gmail=
_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:=
1ex">
</blockquote></div></div></div>

--000000000000e1d12e064a497f0f--