Re: Multi-second pauses blocking even trivial activity

From: Patrick Molgaard <draaglom(at)gmail(dot)com>
To: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Multi-second pauses blocking even trivial activity
Date: 2018-09-08 00:34:04
Message-ID: CA+Zan4tLO5qCdNv4APtw7N=N52WsNn_kvpkE5Vbji+KP8zQWnQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

This sounds extremely plausible -- thanks for the tip, Andreas.

Best,
Patrick

On Fri, 7 Sep 2018, 19:20 Andreas Kretschmer, <andreas(at)a-kretschmer(dot)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
>
>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Justin Pryzby 2018-09-08 01:29:57 link to Slow_Query_Questions from wiki/Main Page
Previous Message Patrick Molgaard 2018-09-08 00:32:36 Re: Multi-second pauses blocking even trivial activity