This sounds extremely plausible -- thanks for the tip, Andreas.
Best,
Patrick
On Fri, 7 Sep 2018, 19:20 Andreas Kretschmer, <andreas(at)a-kretschmer(dot)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
>
>