MVCC, WAL, vacuum, and replication slots under sustained delete load - and how to delete billions of rows without your database noticing


Most "how to delete a lot of rows" articles stop at "batch it and delete children before parents." That advice is correct, it's table stakes, and everyone already knows it. This article is about everything...