Jeff Frost <j...@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
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
