Re: Purging few months old data and vacuuming in production

On 1/7/23 05:29, Peter J. Holzer wrote:
[snip]

If I understood correctly, you have to delete about 3 million records

(worst case) from the main table each day. Including the other 8 tables
those are 27 million DELETE queries each of which deletes only a few
records. That's about 300 queries per second. I'd be worried about
impacting performance on other queries at this rate.

300 records/second.  Fewer DELETE statements if there are one-many relationships with the child tables.

I'd go for a middle ground: Instead of expiring once per day, use a
shorter interval, maybe once per hour or once per minute. That will
(probably) make each expire job really quick but still create much less
load overall.