THE ONLY SCALABLE DELETE IN POSTGRES IS DROP TABLE
Large Postgres DELETEs add work rather than reclaim it. They leave dead tuples, add replication overhead, and don't return disk space, while DROP TABLE and TRUNCATE remove files directly and scale independently of data size. It's best to structure your schema so bulk deletion becomes a DROP or TRUNCATE.