<msalais@xxxxxxx> writes: > How a COMMIT statement could be blocked by a lock whatever the kind of the lock could be. COMMIT releases locks. How could it be blocked by a lock?! There could be pre-commit actions (for example, firing deferred triggers) that need to take locks the transaction didn't already hold. You've provided no details that would let anyone diagnose the exact cause, though. regards, tom lane
