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