The only scalable delete in Postgres is DROP TABLE

Software Development, Database & Storage(planetscale.com)view on HackerNews
PostgreSQLDELETEDROP TABLETRUNCATEdatabase performancescalability

Author: hollylawly

Date: 6/11/2026

Article Summary:
The article discusses the inefficiencies of large DELETE operations in PostgreSQL and recommends using DROP TABLE or TRUNCATE instead, as they are more scalable and performant.