This sounds extremely plausible -- thanks for the tip, Andreas.Best,PatrickOn 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
> >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:
Соглашаюсь с условиями обработки персональных данных