Postgres DELETE Can Actually Scale
Summary
The article analyzes why PostgreSQL deletes can scale in large, durable-workflow scenarios. It explains MVCC churn, the role of VACUUM, and cache locality in delete performance, then outlines practical optimizations such as dropping foreign keys, batching deletions, and using anti-joins. It also discusses the trade-offs with partitions and when each approach makes sense for retention policies.