MIME-Version: 1.0
References: <CAJCZkoLkMLsz1raz+XLJ09PUdgWv7mw37+zaFw9jNMhFUC+SVg@mail.gmail.com>
 <CANzqJaAyfk4BFEcSARByt=TinBLRWT8uPffEA9dY8qZ8bhsRGw@mail.gmail.com>
In-Reply-To: <CANzqJaAyfk4BFEcSARByt=TinBLRWT8uPffEA9dY8qZ8bhsRGw@mail.gmail.com>
From: Durgamahesh Manne <maheshpostgres9@gmail.com>
Date: Sat, 7 Jun 2025 04:39:20 +0530
Message-ID: <CAJCZkoJ09T3YN2duJAQC1GH6yn9zxF06azRb_C5DGnKyAGPgPw@mail.gmail.com>
Subject: Re: Regarding fillfactor use case for only delete ops
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000d202f40636ef4251"
Archived-At: <https://www.postgresql.org/message-id/CAJCZkoJ09T3YN2duJAQC1GH6yn9zxF06azRb_C5DGnKyAGPgPw%40mail.gmail.com>
Precedence: bulk

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

On Fri, Jun 6, 2025 at 7:31=E2=80=AFPM Ron Johnson <ronljohnsonjr@gmail.com=
> wrote:

> On Fri, Jun 6, 2025 at 4:36=E2=80=AFAM Durgamahesh Manne <
> maheshpostgres9@gmail.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
>> tables 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 tabl=
es
>>
>
> This confuses me.  It seems that you are deleting old data instead of jus=
t
> dropping the old partitions.
>
> What did I misunderstand?
>
> --
> Death to <Redacted>, and butter sauce.
> Don't boil me, I'm still alive.
> <Redacted> lobster!
>

Hi

I have partitioned table with retention policy of 90 days and will be auto
purged partitions beyond 90 days and  for last 90 days tables inserts and
deletes usually run through apl call
Here due to deletes ops on last 90 days weekly partitions bloat generates
50gb to 60gb for on weekly partition even we set autovacuum params already
in place for at child tables level

Regards,
Durga Mahesh

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

<div dir=3D"ltr"><div dir=3D"ltr"><br></div><br><div class=3D"gmail_quote g=
mail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">On Fri, Jun 6, =
2025 at 7:31=E2=80=AFPM Ron Johnson &lt;<a href=3D"mailto:ronljohnsonjr@gma=
il.com">ronljohnsonjr@gmail.com</a>&gt; wrote:<br></div><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr">On Fri, =
Jun 6, 2025 at 4:36=E2=80=AFAM Durgamahesh Manne &lt;<a href=3D"mailto:mahe=
shpostgres9@gmail.com" target=3D"_blank">maheshpostgres9@gmail.com</a>&gt; =
wrote:</div><div class=3D"gmail_quote"><blockquote class=3D"gmail_quote" st=
yle=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padd=
ing-left:1ex"><div dir=3D"ltr">Hi=C2=A0 Team<div><br></div><div>Can we gene=
rate a fill factor for tables that have delete ops ?</div><div><br></div><d=
iv>Does the fill factor really work and help to minimize the bloat for tabl=
es that have delete ops?</div><div><br></div><div>I have parent table with =
weekly partitions So for every week 50 to 60 gb of bloat generates and auto=
vacuum params already in place for child tables=C2=A0</div></div></blockquo=
te><div><br></div><div>This confuses me.=C2=A0 It seems that you are deleti=
ng old data instead of just dropping the old partitions.</div></div><div><b=
r></div><div>What did I misunderstand?</div><div><br></div><span class=3D"g=
mail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signat=
ure"><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;Redacted&gt; lobster!<=
/div></div></div></div></div></div></blockquote><div><br></div><div>Hi=C2=
=A0</div><div><br></div><div>I have partitioned table with retention policy=
 of 90 days and will be auto purged partitions beyond 90 days and=C2=A0 for=
 last 90 days tables inserts and deletes usually run through apl call=C2=A0=
</div><div>Here due to deletes ops on last 90 days weekly partitions bloat =
generates 50gb to 60gb for on weekly partition even we set autovacuum param=
s already in place for at child tables level=C2=A0</div><div><br></div><div=
>Regards,</div><div>Durga Mahesh=C2=A0</div></div></div>

--000000000000d202f40636ef4251--