public inbox for [email protected]help / color / mirror / Atom feed
Regarding fillfactor use case for only delete ops 5+ messages / 4 participants [nested] [flat]
* Regarding fillfactor use case for only delete ops @ 2025-06-06 08:40 Durgamahesh Manne <[email protected]> 0 siblings, 2 replies; 5+ messages in thread From: Durgamahesh Manne @ 2025-06-06 08:40 UTC (permalink / raw) To: pgsql-general <[email protected]> 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 ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Regarding fillfactor use case for only delete ops @ 2025-06-06 12:57 Laurenz Albe <[email protected]> parent: Durgamahesh Manne <[email protected]> 1 sibling, 0 replies; 5+ messages in thread From: Laurenz Albe @ 2025-06-06 12:57 UTC (permalink / raw) To: Durgamahesh Manne <[email protected]>; pgsql-general <[email protected]> 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 ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Regarding fillfactor use case for only delete ops @ 2025-06-06 14:01 Ron Johnson <[email protected]> parent: Durgamahesh Manne <[email protected]> 1 sibling, 1 reply; 5+ messages in thread From: Ron Johnson @ 2025-06-06 14:01 UTC (permalink / raw) To: pgsql-general On Fri, Jun 6, 2025 at 4:36 AM Durgamahesh Manne <[email protected]> wrote: > 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 > This confuses me. It seems that you are deleting old data instead of just dropping the old partitions. What did I misunderstand? -- Death to <Redacted>, and butter sauce. Don't boil me, I'm still alive. <Redacted> lobster! ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Regarding fillfactor use case for only delete ops @ 2025-06-06 23:09 Durgamahesh Manne <[email protected]> parent: Ron Johnson <[email protected]> 0 siblings, 1 reply; 5+ messages in thread From: Durgamahesh Manne @ 2025-06-06 23:09 UTC (permalink / raw) To: Ron Johnson <[email protected]>; +Cc: pgsql-general On Fri, Jun 6, 2025 at 7:31 PM Ron Johnson <[email protected]> wrote: > On Fri, Jun 6, 2025 at 4:36 AM Durgamahesh Manne < > [email protected]> wrote: > >> 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 >> > > This confuses me. It seems that you are deleting old data instead of just > dropping the old partitions. > > What did I misunderstand? > > -- > Death to <Redacted>, and butter sauce. > Don't boil me, I'm still alive. > <Redacted> lobster! > Hi I have partitioned table with retention policy of 90 days and will be auto purged partitions beyond 90 days and for last 90 days tables inserts and deletes usually run through apl call Here due to deletes ops on last 90 days weekly partitions bloat generates 50gb to 60gb for on weekly partition even we set autovacuum params already in place for at child tables level Regards, Durga Mahesh ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Regarding fillfactor use case for only delete ops @ 2025-06-06 23:20 Adrian Klaver <[email protected]> parent: Durgamahesh Manne <[email protected]> 0 siblings, 0 replies; 5+ messages in thread From: Adrian Klaver @ 2025-06-06 23:20 UTC (permalink / raw) To: Durgamahesh Manne <[email protected]>; Ron Johnson <[email protected]>; +Cc: pgsql-general On 6/6/25 16:09, Durgamahesh Manne wrote: > > Hi > > I have partitioned table with retention policy of 90 days and will be > auto purged partitions beyond 90 days and for last 90 days tables > inserts and deletes usually run through apl call > Here due to deletes ops on last 90 days weekly partitions bloat > generates 50gb to 60gb for on weekly partition even we set autovacuum > params already in place for at child tables level 1) How are you measuring bloat? 2) Are inserts being done on the partitions all the way out to the 90 days? > > Regards, > Durga Mahesh -- Adrian Klaver [email protected] ^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2025-06-06 23:20 UTC | newest] Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-06-06 08:40 Regarding fillfactor use case for only delete ops Durgamahesh Manne <[email protected]> 2025-06-06 12:57 ` Laurenz Albe <[email protected]> 2025-06-06 14:01 ` Ron Johnson <[email protected]> 2025-06-06 23:09 ` Durgamahesh Manne <[email protected]> 2025-06-06 23:20 ` Adrian Klaver <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox