Re: debugging intermittent slow updates under higher load - Mailing list pgsql-general

From Pavel Stehule
Subject Re: debugging intermittent slow updates under higher load
Date
Msg-id CAFj8pRBERCvnjdVQiZTFwqa+==eHRhtsVf1QuOH66+mB28DPCw@mail.gmail.com
Whole thread Raw
In response to Re: debugging intermittent slow updates under higher load  (Chris Withers <chris@withers.org>)
List 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 by date:

Previous
From: Chris Withers
Date:
Subject: Re: debugging intermittent slow updates under higher load
Next
From: Johann Spies
Date:
Subject: How to build a btree index with integer values on jsonb data?