Re: Multi-second pauses blocking even trivial activity

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Multi-second pauses blocking even trivial activity
Дата
Msg-id CAMkU=1xqJgnEEnYCnVbQXZpYxLfw6PokXDR3A68THjqN-Fnqhw@mail.gmail.com
обсуждение исходный текст
Ответ на Multi-second pauses blocking even trivial activity  (Patrick Molgaard <draaglom@gmail.com>)
Ответы Re: Multi-second pauses blocking even trivial activity  (Patrick Molgaard <draaglom@gmail.com>)
Список pgsql-performance
Дерево обсуждения
On Fri, Sep 7, 2018 at 8:00 AM Patrick Molgaard <draaglom@gmail.com> wrote:
Hi folks,

I've been seeing some curious behaviour on a postgres server I administer.

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:

`LOG: duration: 22627.299 ms statement: SET client_encoding='''utf-8''';` 


Do you have log_lock_waits set to on?  If not, you might want to turn it on.

Cheers,

Jeff

В списке pgsql-performance по дате отправления:

Предыдущее
От: Patrick Molgaard
Дата:
Сообщение: Multi-second pauses blocking even trivial activity
Следующее
От: Felix Geisendörfer
Дата:
Сообщение: GIN Index has O(N^2) complexity for array overlap operator?