On 7/20/22 09:26, Rama Krishnan wrote:
> Hi Adrian,
>
> Thanks for the update.
>
>
> Is it possible to achieve 10000 records deletion on every iteration
> because my original table contains 5M records during the deletion
> process it consumes more cpu and resources.
See here
<https://www.postgresql.org/docs/current/functions-datetime.html> for
date manipulation functions. you can delete by month or week, which
ever makes it fit your hardware