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 for date manipulation functions. you can delete by month or week, which ever makes it fit your hardware