On Fri, Sep 7, 2018 at 8:00 AM Patrick Molgaard <draaglom@xxxxxxxxx> 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
