Re: Postgres Replaying WAL slowly

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Postgres Replaying WAL slowly
Дата
Msg-id 20300.1404156750@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Postgres Replaying WAL slowly  (Jeff Frost <jeff@pgexperts.com>)
Ответы Re: Postgres Replaying WAL slowly  (Jeff Frost <jeff@pgexperts.com>)
Список pgsql-performance
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


В списке pgsql-performance по дате отправления:

Предыдущее
От: Jeff Frost
Дата:
Сообщение: Re: Postgres Replaying WAL slowly
Следующее
От: Jeff Frost
Дата:
Сообщение: Re: Postgres Replaying WAL slowly