PARTITION
instead of regular DELETE ... WHERE created_at ...
to avoid any performance impact when deleting a large chunk of data. DELETE
on a table with millions of rows can take several minutes and block incoming transactions, whereas DROPing
a TABLE (partition)
is faster and should not block incoming transactions.