Message-ID: <84b6da7feb3de406d20a4a0e80954520a6db6b6c.camel@cybertec.at>
Subject: Re: Regarding fillfactor use case for only delete ops
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: Durgamahesh Manne <maheshpostgres9@gmail.com>, pgsql-general
	 <pgsql-general@lists.postgresql.org>
Date: Sat, 07 Jun 2025 13:53:14 +0200
In-Reply-To: <CANzqJaB8aRCuEYYDU_qK0WUVVdWdoCte=wDt5387uj=Ncw5_Pg@mail.gmail.com>
References: 
	<CAJCZkoLkMLsz1raz+XLJ09PUdgWv7mw37+zaFw9jNMhFUC+SVg@mail.gmail.com>
	 <65a54f809d0339d9d6021c35f7fa14fc20a7f2e6.camel@cybertec.at>
	 <CANzqJaB8aRCuEYYDU_qK0WUVVdWdoCte=wDt5387uj=Ncw5_Pg@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.56.2 (3.56.2-1.fc42) 
MIME-Version: 1.0
Archived-At: <https://www.postgresql.org/message-id/84b6da7feb3de406d20a4a0e80954520a6db6b6c.camel%40cybertec.at>
Precedence: bulk

On Fri, 2025-06-06 at 09:59 -0400, Ron Johnson wrote:
> On Fri, Jun 6, 2025 at 8:57=E2=80=AFAM Laurenz Albe <laurenz.albe@cyberte=
c.at> 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 ?
> > >=20
> > > Does the fill factor really work and help to minimize the bloat for t=
ables that have delete ops?
> > >=20
> > > 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 tab=
les=C2=A0
> >=20
> > Nothing can ever avoid bloat caused by DELETE, except partitioning in a
> > way that you can drop a partition rather than running DELETE.
>=20
> Isn't the fill factor aimed at reducing bloat during updates of HOT table=
s?

Yes, but not during DELETEs.

HOT updates also don't directly avoid bloat on tables; only on indexes.
They reduce the bloat on tables inderectly, because the dead tuples can
be cleaned up with less effort.

Yours,
Laurenz Albe