public inbox for [email protected]
help / color / mirror / Atom feedFrom: Ron Johnson <[email protected]>
To: Laurenz Albe <[email protected]>
Cc: Durgamahesh Manne <[email protected]>
Cc: pgsql-general <[email protected]>
Subject: Re: Regarding fillfactor use case for only delete ops
Date: Fri, 6 Jun 2025 09:59:14 -0400
Message-ID: <CANzqJaB8aRCuEYYDU_qK0WUVVdWdoCte=wDt5387uj=Ncw5_Pg@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAJCZkoLkMLsz1raz+XLJ09PUdgWv7mw37+zaFw9jNMhFUC+SVg@mail.gmail.com>
<[email protected]>
On Fri, Jun 6, 2025 at 8:57 AM Laurenz Albe <[email protected]>
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 gb
> of bloat generates and autovacuum params already in place for child tables
>
> 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?
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
view thread (3+ 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], [email protected], [email protected], [email protected]
Subject: Re: Regarding fillfactor use case for only delete ops
In-Reply-To: <CANzqJaB8aRCuEYYDU_qK0WUVVdWdoCte=wDt5387uj=Ncw5_Pg@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