The only scalable delete in Postgres is DROP TABLE — PlanetScale

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

Raccontata daplanetscale.com