Postgres DELETE has a bad reputation, with many high-performance systems opting to avoid deletes entirely, instead cleaning up data by truncating entire tables or dropping entire partitions. If deletes didn't scale, that would be a shame, because DELETE is far more flexible than dropping partitions or tables, especially when data is heterogeneous and you need to store some items longer ...