On Fri, Sep 7, 2018 at 8:00 AM Patrick Molgaard <draaglom(at)gmail(dot)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