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
adrian.klaver@aklaver.com