Postgres Pro
Downloads
Home   >   mailing lists

Re: Regarding fillfactor use case for only delete ops - Mailing list pgsql-general

From Laurenz Albe
Subject Re: Regarding fillfactor use case for only delete ops
Date
Msg-id 65a54f809d0339d9d6021c35f7fa14fc20a7f2e6.camel@cybertec.at
Whole thread Raw
In response to Regarding fillfactor use case for only delete ops  (Durgamahesh Manne <maheshpostgres9@gmail.com>)
Responses Re: Regarding fillfactor use case for only delete ops
List pgsql-general
Tree view 
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
alreadyin 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.

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: Arnold Hendriks
Date:
Subject: Low OIDs (< 16384) when creating databases in single user mode
Next
From: Ron Johnson
Date:
Subject: Re: Regarding fillfactor use case for only delete ops