Re: Multi-second pauses blocking even trivial activity

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
To: pgsql-performance(at)lists(dot)postgresql(dot)org,Patrick Molgaard <draaglom(at)gmail(dot)com>
Subject: Re: Multi-second pauses blocking even trivial activity
Date: 2018-09-07 18:12:18
Message-ID: DEC36FD8-41AD-4CDA-BC6C-72D04F12882B@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Joshua D. Drake 2018-09-07 18:22:52 Re: Multi-second pauses blocking even trivial activity
Previous Message Patrick Molgaard 2018-09-07 18:03:17 Re: Multi-second pauses blocking even trivial activity