Sachin Kotwal <kotsac...@gmail.com> writes: > Does it release locks after taking decision and then perform actual update > operation on partition table?
No, there's no attempt to do that, and we're unlikely to consider doing so because it would result in more lock-table thrashing. Why do you care? RowExclusiveLock does not block any normal DML operation, so there's no apparent benefit from releasing it early. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers