Jeff Frost <jeff@xxxxxxxxxxxxx> writes: > Sampling pg_locks on the primary shows ~50 locks with ExclusiveLock mode: > mode | count > --------------------------+------- > AccessExclusiveLock | 11 > AccessShareLock | 2089 > ExclusiveLock | 46 > RowExclusiveLock | 81 > RowShareLock | 17 > ShareLock | 4 > ShareUpdateExclusiveLock | 5 That's not too helpful if you don't pay attention to what the lock is on; it's likely that all the ExclusiveLocks are on transactions' own XIDs, which isn't relevant to the standby's behavior. The AccessExclusiveLocks are probably interesting though --- you should look to see what those are on. regards, tom lane
