Feedback-ID: i76984098:Fastmail
Message-ID: <68dbc93c-2a1a-409f-9aed-d7d3e316e415@aklaver.com>
Date: Fri, 6 Jun 2025 16:20:23 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Regarding fillfactor use case for only delete ops
To: Durgamahesh Manne <maheshpostgres9@gmail.com>,
 Ron Johnson <ronljohnsonjr@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
References: <CAJCZkoLkMLsz1raz+XLJ09PUdgWv7mw37+zaFw9jNMhFUC+SVg@mail.gmail.com>
 <CANzqJaAyfk4BFEcSARByt=TinBLRWT8uPffEA9dY8qZ8bhsRGw@mail.gmail.com>
 <CAJCZkoJ09T3YN2duJAQC1GH6yn9zxF06azRb_C5DGnKyAGPgPw@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAJCZkoJ09T3YN2duJAQC1GH6yn9zxF06azRb_C5DGnKyAGPgPw@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/68dbc93c-2a1a-409f-9aed-d7d3e316e415%40aklaver.com>
Precedence: bulk

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