DROP TABLE, not DELETE, is the only scalable way to purge PostgreSQL data
Massive PostgreSQL DELETEs leave dead tuples, tax replication, and never return disk space. Using DROP TABLE or TRUNCATE removes the underlying files, scaling independently of row count. Redesign schemas to treat bulk removal as table drops and you’ll avoid the hidden cost of large deletes.