Re: Postgres Replaying WAL slowly

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