Re: Regarding fillfactor use case for only delete ops

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Regarding fillfactor use case for only delete ops
Date: 2025-06-06 14:01:19
Message-ID: CANzqJaAyfk4BFEcSARByt=TinBLRWT8uPffEA9dY8qZ8bhsRGw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jun 6, 2025 at 4:36 AM Durgamahesh Manne <maheshpostgres9(at)gmail(dot)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 tables
>

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

What did I misunderstand?

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2025-06-06 14:32:11 Re: Low OIDs (< 16384) when creating databases in single user mode
Previous Message Ron Johnson 2025-06-06 13:59:14 Re: Regarding fillfactor use case for only delete ops