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. Yours, Laurenz Albe
