
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.
Tap to vote and see what everyone thinks.