Andreas -- just following up to say that this was indeed the root cause. Thanks again.
Patrick On Sat, 8 Sep 2018, 01:34 Patrick Molgaard, <draag...@gmail.com> wrote: > This sounds extremely plausible -- thanks for the tip, Andreas. > > Best, > Patrick > > > On Fri, 7 Sep 2018, 19:20 Andreas Kretschmer, <andr...@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 >> >>
