Jeff Frost <jeff@pgexperts.com> 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