The only scalable delete in Postgres is DROP TABLE

What happened

Large DELETEs add work instead of reclaiming it. Structure your database so deletion becomes DROP TABLE or TRUNCATE.

Summary assembled by rule from the sources below

Sources