Hi Akash,

A delete operation in itself is not necessarily expensive, but when we compare the costs for deleting all individual rows from a partition with simply dropping a partition a delete is very expensive. It would touch all rows to mark them as being deleted and later the VACUUM has to go over these rows again.

If we compare this with a single update in the catalog marking the entire table as being deleted, the difference can hardly be bigger.

- Cosmin