Re: BUG #14714: long running sessions from remote instance seems to hang some times

From: Andres Freund <andres(at)anarazel(dot)de>
To: Josef Machytka <josef(dot)machytka(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14714: long running sessions from remote instance seems to hang some times
Date: 2017-06-26 15:40:26
Message-ID: 20170626154026.mg5tftlnzh2bh7az@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,

(please don't top-quote on this list)

On 2017-06-26 12:27:04 +0200, Josef Machytka wrote:
> Debian 8:
> Linux <hostname> 3.16.0-4-amd64 #1 SMP Debian 3.16.43-2+deb8u1 (2017-06-18)
> x86_64 GNU/Linux

You should chekc the following parameters:
cat /proc/sys/vm/zone_reclaim_mode
cat /sys/kernel/mm/transparent_hugepage/enabled
and disable them:
echo 0 > /proc/sys/vm/zone_reclaim_mode
echo never > /sys/kernel/mm/transparent_hugepage/enabled

- Andres

Greetings,

Andres Freund

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Caio Parolin 2017-06-26 15:44:33 RES: Problems installation
Previous Message paolo.guagliardo 2017-06-26 15:29:34 BUG #14717: NULL=NULL is true for composite types