Re: AccessShareLock and Resource Contention

Поиск
Список
Период
Сортировка
От maillists0@gmail.com
Тема Re: AccessShareLock and Resource Contention
Дата
Msg-id CAB+OxSDWfSDRfQz_owg-x=UCnGNu8Am2pSVW7M+iHfiT2WO2CQ@mail.gmail.com
обсуждение исходный текст
Ответ на AccessShareLock and Resource Contention  (maillists0@gmail.com)
Ответы Re: AccessShareLock and Resource Contention
Re: AccessShareLock and Resource Contention
Список pgsql-general
Дерево обсуждения
Hit send on that one too soon. I see 6.5k access share locks out of 7.5k transactions.


On Tue, Nov 26, 2013 at 12:41 PM, <maillists0@gmail.com> wrote:
I have a 9.2 server that occasionally becomes CPU bound. Disk wait is nominal and there's no memory pressure. The workload is almost all reads and the cache hit rate is high.

For some one minute periods, my monitoring shows around 1.5k to 2k access share locks out of a total of 7.5 to 8k transactions. What's the best strategy for finding out if that is creating a bottleneck?

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

Предыдущее
От: maillists0@gmail.com
Дата:
Сообщение: AccessShareLock and Resource Contention
Следующее
От: Mike Broers
Дата:
Сообщение: Re: Re: corruption issue after server crash - ERROR: unexpected chunk number 0