MIME-Version: 1.0
References: <CAJCZkoLkMLsz1raz+XLJ09PUdgWv7mw37+zaFw9jNMhFUC+SVg@mail.gmail.com>
 <65a54f809d0339d9d6021c35f7fa14fc20a7f2e6.camel@cybertec.at>
In-Reply-To: <65a54f809d0339d9d6021c35f7fa14fc20a7f2e6.camel@cybertec.at>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Fri, 6 Jun 2025 09:59:14 -0400
Message-ID: <CANzqJaB8aRCuEYYDU_qK0WUVVdWdoCte=wDt5387uj=Ncw5_Pg@mail.gmail.com>
Subject: Re: Regarding fillfactor use case for only delete ops
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Durgamahesh Manne <maheshpostgres9@gmail.com>, 
	pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000519dd40636e7a361"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaB8aRCuEYYDU_qK0WUVVdWdoCte%3DwDt5387uj%3DNcw5_Pg%40mail.gmail.com>
Precedence: bulk

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

On Fri, Jun 6, 2025 at 8:57=E2=80=AFAM Laurenz Albe <laurenz.albe@cybertec.=
at>
wrote:

> On Fri, 2025-06-06 at 14:10 +0530, Durgamahesh Manne wrote:
> > Can we generate a fill factor for tables that have delete ops ?
> >
> > Does the fill factor really work and help to minimize the bloat for
> tables that have delete ops?
> >
> > I have parent table with weekly partitions So for every week 50 to 60 g=
b
> of bloat generates and autovacuum params already in place for child table=
s
>
> Nothing can ever avoid bloat caused by DELETE, except partitioning in a
> way that you can drop a partition rather than running DELETE.
>
>
Laurenz,

Isn't the fill factor aimed at reducing bloat during updates of HOT tables?

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

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

<div dir=3D"ltr"><div dir=3D"ltr">On Fri, Jun 6, 2025 at 8:57=E2=80=AFAM La=
urenz Albe &lt;<a href=3D"mailto:laurenz.albe@cybertec.at">laurenz.albe@cyb=
ertec.at</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_containe=
r"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bord=
er-left:1px solid rgb(204,204,204);padding-left:1ex">On Fri, 2025-06-06 at =
14:10 +0530, Durgamahesh Manne wrote:<br>
&gt; Can we generate a fill factor for tables that have delete ops ?<br>
&gt; <br>
&gt; Does the fill factor really work and help to minimize the bloat for ta=
bles that have delete ops?<br>
&gt; <br>
&gt; I have parent table with weekly partitions So for every week 50 to 60 =
gb of bloat generates and autovacuum params already in place for child tabl=
es=C2=A0<br>
<br>
Nothing can ever avoid bloat caused by DELETE, except partitioning in a<br>
way that you can drop a partition rather than running DELETE.<br><br></bloc=
kquote><div><br></div><div>Laurenz,</div><div><br></div><div>Isn&#39;t the =
fill factor aimed at reducing bloat during updates of HOT tables?</div></di=
v><div><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;Redacte=
d&gt;, and butter sauce.<div>Don&#39;t boil me, I&#39;m still alive.<br><di=
v><div>&lt;Redacted&gt; lobster!</div></div></div></div></div></div>

--000000000000519dd40636e7a361--