The only scalable delete in Postgres is DROP TABLE

The only scalable delete in Postgres is DROP TABLE Tom Pang | Counterintuitively, large DELETEs add work to the database. From experience we can plainly claim the following: the most scalable Postgres data-deletion strategies revolve around deleting entire tables. Individual row DELETE is fine at a small scale. However, big batch DELETE operations don't immediately free up physical disk space, add write and replication overhead, and are ultimately not good for large scale row cleanup. If your...