public inbox for [email protected]
help / color / mirror / Atom feedFrom: Ron Johnson <[email protected]>
To: pgsql-general <[email protected]>
Subject: Re: Regarding fillfactor use case for only delete ops
Date: Fri, 6 Jun 2025 10:01:19 -0400
Message-ID: <CANzqJaAyfk4BFEcSARByt=TinBLRWT8uPffEA9dY8qZ8bhsRGw@mail.gmail.com> (raw)
In-Reply-To: <CAJCZkoLkMLsz1raz+XLJ09PUdgWv7mw37+zaFw9jNMhFUC+SVg@mail.gmail.com>
References: <CAJCZkoLkMLsz1raz+XLJ09PUdgWv7mw37+zaFw9jNMhFUC+SVg@mail.gmail.com>
On Fri, Jun 6, 2025 at 4:36 AM Durgamahesh Manne <[email protected]>
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!
view thread (5+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected]
Subject: Re: Regarding fillfactor use case for only delete ops
In-Reply-To: <CANzqJaAyfk4BFEcSARByt=TinBLRWT8uPffEA9dY8qZ8bhsRGw@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox