Search Postgresql Archives

Re: debugging intermittent slow updates under higher load

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi

čt 6. 12. 2018 v 12:18 odesílatel Chris Withers <chris@xxxxxxxxxxx> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux