TechPlanetScale4 days ago
The only scalable delete in Postgres is DROP TABLE
6 min read
Postgres identifies DROP TABLE as the only scalable delete operation for large datasets. Individual row DELETEs create write overhead and do not free disk space immediately. DROP TABLE removes entire table data and avoids replication and transactional write delays. Data remains in heap pages until vacuum processes reclaim space.
Level
Hype check
Tap to vote and see what everyone thinks.
