MIME-Version: 1.0
References: <CAJCZkoLkMLsz1raz+XLJ09PUdgWv7mw37+zaFw9jNMhFUC+SVg@mail.gmail.com>
In-Reply-To: <CAJCZkoLkMLsz1raz+XLJ09PUdgWv7mw37+zaFw9jNMhFUC+SVg@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Fri, 6 Jun 2025 10:01:19 -0400
Message-ID: <CANzqJaAyfk4BFEcSARByt=TinBLRWT8uPffEA9dY8qZ8bhsRGw@mail.gmail.com>
Subject: Re: Regarding fillfactor use case for only delete ops
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000c199730636e7aa7f"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaAyfk4BFEcSARByt%3DTinBLRWT8uPffEA9dY8qZ8bhsRGw%40mail.gmail.com>
Precedence: bulk

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

On Fri, Jun 6, 2025 at 4:36=E2=80=AFAM Durgamahesh Manne <maheshpostgres9@g=
mail.com>
wrote:

> Hi  Team
>
> 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 table=
s
> that have delete ops?
>
> 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 table=
s
>

This confuses me.  It seems that you are deleting old data instead of just
dropping the old partitions.

What did I misunderstand?

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

--000000000000c199730636e7aa7f
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 4:36=E2=80=AFAM Du=
rgamahesh Manne &lt;<a href=3D"mailto:maheshpostgres9@gmail.com">maheshpost=
gres9@gmail.com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_c=
ontainer"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8=
ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr=
">Hi=C2=A0 Team<div><br></div><div>Can we generate a fill factor for tables=
 that have delete ops ?</div><div><br></div><div>Does the fill factor reall=
y work and help to minimize the bloat for tables that have delete ops?</div=
><div><br></div><div>I have parent table with weekly partitions So for ever=
y week 50 to 60 gb of bloat generates and autovacuum params already in plac=
e for child tables=C2=A0</div></div></blockquote><div><br></div><div>This c=
onfuses me.=C2=A0 It seems that you are deleting old data instead of just d=
ropping the old partitions.</div></div><div><br></div><div>What did I misun=
derstand?</div><div><br></div><span class=3D"gmail_signature_prefix">-- </s=
pan><br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr">Death t=
o &lt;Redacted&gt;, 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>

--000000000000c199730636e7aa7f--