| 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-21 19:07:07 |
| Message-ID: | CA+Zan4sW0sc6iqedjsFTD-AAbbpDPbqBc0QyZiNUr7TPOzaSqw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Andreas -- just following up to say that this was indeed the root cause.
Thanks again.
Patrick
On Sat, 8 Sep 2018, 01:34 Patrick Molgaard, <draaglom(at)gmail(dot)com> wrote:
> 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
>>
>>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vladimir Ryabtsev | 2018-09-22 09:19:40 | Re: Why could different data in a table be processed with different performance? |
| Previous Message | Fabio Pardi | 2018-09-21 13:12:58 | Re: Why could different data in a table be processed with different performance? |