Re: Multi-second pauses blocking even trivial activity

Поиск
Список
Период
Сортировка
От Andreas Kretschmer
Тема Re: Multi-second pauses blocking even trivial activity
Дата
Msg-id DEC36FD8-41AD-4CDA-BC6C-72D04F12882B@a-kretschmer.de
обсуждение исходный текст
Ответ на Multi-second pauses blocking even trivial activity  (Patrick Molgaard <draaglom@gmail.com>)
Ответы Re: Multi-second pauses blocking even trivial activity  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: Multi-second pauses blocking even trivial activity  (Patrick Molgaard <draaglom@gmail.com>)
Список pgsql-performance
Дерево обсуждения 
>
>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 по дате отправления:

Предыдущее
От: Patrick Molgaard
Дата:
Сообщение: Re: Multi-second pauses blocking even trivial activity
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Multi-second pauses blocking even trivial activity