Postgres DELETE Can Actually Scale
Summary
Postgres DELETE Can Actually Scale argues that DELETE operations in Postgres, while expensive under MVCC, can be scaled with targeted optimizations. The article covers how MVCC creates dead tuples, how VACUUM and caching impact performance, and practical steps like dropping foreign keys, batch deletes, anti-joins, and manual VACUUM to improve retention workloads. It also explains why partitioning is not a one-size-fits-all solution for long-running workflows.