Hi Akash,

Detaching can be done without an ACCESS EXCLUSIVE LOCK on the parent table. But we like to detach partitions before dropping them for a second reason. We have fully automated the process for dropping old data and I tend to be careful. As soon as we detach a child table, the data in this table is no longer visible from the applications perspective. But if we, for whatever reason, detached this table while we should have not, it is very easy to attach this table again. If we would have dropped the table immediately we would have to recover this data from a backup, which takes much longer.

- Derk