The only scalable delete in Postgres is DROP TABLE (opens in new tab)
Large DELETEs add work instead of reclaiming it. Structure your database so deletion becomes DROP TABLE or TRUNCATE.
Read the original articleLarge DELETEs add work instead of reclaiming it. Structure your database so deletion becomes DROP TABLE or TRUNCATE.
Read the original article