Regarding fillfactor use case for only delete ops

From: Durgamahesh Manne <maheshpostgres9(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Regarding fillfactor use case for only delete ops
Date: 2025-06-06 08:40:46
Message-ID: CAJCZkoLkMLsz1raz+XLJ09PUdgWv7mw37+zaFw9jNMhFUC+SVg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Regards,
Durga Mahesh

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Arnold Hendriks 2025-06-06 09:16:15 Low OIDs (< 16384) when creating databases in single user mode
Previous Message Jeff Davis 2025-06-05 22:09:34 Re: LOCALE C.UTF-8 on EDB Windows v17 server