public inbox for [email protected]  

help / color / mirror / Atom feed

From: Adrian Klaver <[email protected]>
To: Durgamahesh Manne <[email protected]>
To: Ron Johnson <[email protected]>
Cc: pgsql-general <[email protected]>
Subject: Re: Regarding fillfactor use case for only delete ops
Date: Fri, 6 Jun 2025 16:20:23 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAJCZkoJ09T3YN2duJAQC1GH6yn9zxF06azRb_C5DGnKyAGPgPw@mail.gmail.com>
References: <CAJCZkoLkMLsz1raz+XLJ09PUdgWv7mw37+zaFw9jNMhFUC+SVg@mail.gmail.com>
	<CANzqJaAyfk4BFEcSARByt=TinBLRWT8uPffEA9dY8qZ8bhsRGw@mail.gmail.com>
	<CAJCZkoJ09T3YN2duJAQC1GH6yn9zxF06azRb_C5DGnKyAGPgPw@mail.gmail.com>

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]

view thread (5+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Regarding fillfactor use case for only delete ops
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox