hard20 pts · first answer countsdatabasespostgresqlperformance

Deleting old log rows every night

A nightly `DELETE FROM api_logs WHERE created_at < now() - interval '90 days'` removes 30 million rows, takes hours and bloats the table. What is a better design?

A.Add an index on created_at and keep deletingB.Run VACUUM FULL after every deleteC.Partition by month and drop old partitionsD.Delete one row at a time in a loop

Discussion 0

Join free to post in the discussion.

Deleting old log rows every night

Discussion 0

Related questions