Re: Multi-second pauses blocking even trivial activity

Поиск
Список
Период
Сортировка
От Patrick Molgaard
Тема Re: Multi-second pauses blocking even trivial activity
Дата
Msg-id CA+Zan4sW0sc6iqedjsFTD-AAbbpDPbqBc0QyZiNUr7TPOzaSqw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Multi-second pauses blocking even trivial activity  (Patrick Molgaard <draaglom@gmail.com>)
Ответы Re: Multi-second pauses blocking even trivial activity  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Список pgsql-performance
Дерево обсуждения
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, <draaglom@gmail.com> wrote:
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 по дате отправления:

Предыдущее
От: Fabio Pardi
Дата:
Сообщение: Re: Why could different data in a table be processed with differentperformance?
Следующее
От: Vladimir Ryabtsev
Дата:
Сообщение: Re: Why could different data in a table be processed with different performance?