Postgres Pro
Downloads
Home   >   mailing lists

Re: Multi-second pauses blocking even trivial activity - Mailing list pgsql-performance

From Patrick Molgaard
Subject Re: Multi-second pauses blocking even trivial activity
Date
Msg-id CA+Zan4tLO5qCdNv4APtw7N=N52WsNn_kvpkE5Vbji+KP8zQWnQ@mail.gmail.com
Whole thread Raw
In response to Re: Multi-second pauses blocking even trivial activity  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Responses Re: Multi-second pauses blocking even trivial activity
List pgsql-performance
Tree view
This sounds extremely plausible -- thanks for the tip, Andreas.

Best,
Patrick

On Fri, 7 Sep 2018, 19:20 Andreas Kretschmer, <andreas@a-kretschmer.de> wrote:

>
>Intermittently (one or two times a week), all queries on that host are
>simultaneously blocked for extended periods (10s of seconds).
>
>The blocked queries are trivial & not related to locking - I'm seeing
>slowlogs of the form:
>


please check if THP are enabled.


Regards, Andreas



--
2ndQuadrant - The PostgreSQL Support Company

pgsql-performance by date:

Previous
From: Patrick Molgaard
Date:
Subject: Re: Multi-second pauses blocking even trivial activity
Next
From: padusuma
Date:
Subject: Re: Performance of INSERT into temporary tables using psqlODBCdriver