Re: debugging intermittent slow updates under higher load

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: debugging intermittent slow updates under higher load
Дата
Msg-id CAFj8pRBERCvnjdVQiZTFwqa+==eHRhtsVf1QuOH66+mB28DPCw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: debugging intermittent slow updates under higher load  (Chris Withers <chris@withers.org>)
Список pgsql-general
Hi

čt 6. 12. 2018 v 12:18 odesílatel Chris Withers <chris@withers.org> napsal:
On 06/12/2018 11:00, Alexey Bashtanov wrote:
>
>> I'm loath to start hacking something up when I'd hope others have done
>> a better job already...
> If you log all queries that take more than a second to complete, is your
> update the only one logged, or something (the would-be blocker) gets
> logged down together with it?

Nope, only ones logged are these updates.

Can you check latency on file system? Some latencies can be enforced by overloaded file system due wrong configuration of file system cache.


Regards

Pavel


Chris

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

Предыдущее
От: Chris Withers
Дата:
Сообщение: Re: debugging intermittent slow updates under higher load
Следующее
От: Johann Spies
Дата:
Сообщение: How to build a btree index with integer values on jsonb data?