Hi Tom,
Thanks for reply.
To take decision it should get locks for very small interval.
Does it release locks after taking decision and then perform actual update operation on partition table?
I feel update operation can take longer time than planner to examine and will not require lock in later stage of query execution.
Locking all partition tables leads to blocking all queries(mostly select * ... kind of) who want lock on other partition.
If we able to release lock immediately after planner examination it will help to get locks to other running queries on other partitions.
If will be happy we will be able to reduce locking in above scenario.
Regards,
Sachin