// PlanetScale Blog · 11 June 2026

The only scalable delete in Postgres is DROP TABLE

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 immedi...

PlanetScale Blog

@planetscale-blog · Tom Pang

planetscale.com

PlanetScale Blog@planetscale-blog