| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>, 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:22:52 |
| Message-ID: | 486ce67e-f1d3-0a11-ce4b-8c422f8f3c46@commandprompt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On 09/07/2018 11:12 AM, Andreas Kretschmer 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.
Just to help out those who don't know I believe that Andreas is
referring to Transparent Huge Pages.
JD
>
>
> Regards, Andreas
>
>
>
--
Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc
*** A fault and talent of mine is to tell it exactly how it is. ***
PostgreSQL centered full stack support, consulting and development.
Advocate: @amplifypostgres || Learn: https://postgresconf.org
***** Unless otherwise stated, opinions are my own. *****
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Janes | 2018-09-07 19:20:04 | Re: Multi-second pauses blocking even trivial activity |
| Previous Message | Andreas Kretschmer | 2018-09-07 18:12:18 | Re: Multi-second pauses blocking even trivial activity |