public inbox for [email protected]
help / color / mirror / Atom feedRegarding 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]>
2025-06-06 12:57 ` Re: Regarding fillfactor use case for only delete ops Laurenz Albe <[email protected]>
2025-06-06 14:01 ` Re: Regarding fillfactor use case for only delete ops Ron Johnson <[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 08:40 Regarding fillfactor use case for only delete ops Durgamahesh Manne <[email protected]>
@ 2025-06-06 12:57 ` Laurenz Albe <[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 08:40 Regarding fillfactor use case for only delete ops Durgamahesh Manne <[email protected]>
@ 2025-06-06 14:01 ` Ron Johnson <[email protected]>
2025-06-06 23:09 ` Re: Regarding fillfactor use case for only delete ops 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 08:40 Regarding fillfactor use case for only delete ops Durgamahesh Manne <[email protected]>
2025-06-06 14:01 ` Re: Regarding fillfactor use case for only delete ops Ron Johnson <[email protected]>
@ 2025-06-06 23:09 ` Durgamahesh Manne <[email protected]>
2025-06-06 23:20 ` Re: Regarding fillfactor use case for only delete ops Adrian Klaver <[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 08:40 Regarding fillfactor use case for only delete ops Durgamahesh Manne <[email protected]>
2025-06-06 14:01 ` Re: Regarding fillfactor use case for only delete ops Ron Johnson <[email protected]>
2025-06-06 23:09 ` Re: Regarding fillfactor use case for only delete ops Durgamahesh Manne <[email protected]>
@ 2025-06-06 23:20 ` Adrian Klaver <[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