Received: from malur.postgresql.org ([2a02:16a8:dc51::56])
	by arkaria.postgresql.org with esmtps
 (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <pgsql-performance-owner+archive@lists.postgresql.org>)
	id 1fyLNB-0002QQ-6E
	for pgsql-performance@arkaria.postgresql.org; Fri, 07 Sep 2018 18:20:49 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-performance-owner+archive@lists.postgresql.org>)
	id 1fyLN9-0001fI-K1
	for pgsql-performance@arkaria.postgresql.org; Fri, 07 Sep 2018 18:20:47 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <andreas@a-kretschmer.de>)
	id 1fyLN9-0001eu-98
	for pgsql-performance@lists.postgresql.org; Fri, 07 Sep 2018 18:20:47 +0000
Received: from mail.i-mark.de ([188.138.104.222])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <andreas@a-kretschmer.de>)
	id 1fyLF1-0001A2-Vc
	for pgsql-performance@lists.postgresql.org; Fri, 07 Sep 2018 18:12:26 +0000
Received: from OnePlus3.fritz.box (unknown [185.38.49.16])
	by mail.i-mark.de (Postfix) with ESMTPSA id 18D0C1580702;
	Fri,  7 Sep 2018 20:12:16 +0200 (CEST)
Authentication-Results: loft7616.startdedicated.de;
        spf=pass (sender IP is 185.38.49.16)
 smtp.mailfrom=andreas@a-kretschmer.de smtp.helo=OnePlus3.fritz.box
Received-SPF: pass (loft7616.startdedicated.de: connection is authenticated)
Date: Fri, 07 Sep 2018 20:12:18 +0200
In-Reply-To: 
 <CA+Zan4vzTKfpkMznCVkndO7XW6s7sMKpBYqNSToM8nOpjVidsw@mail.gmail.com>
References: 
 <CA+Zan4vzTKfpkMznCVkndO7XW6s7sMKpBYqNSToM8nOpjVidsw@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain;
 charset=utf-8
Content-Transfer-Encoding: quoted-printable
Subject: Re: Multi-second pauses blocking even trivial activity
To: pgsql-performance@lists.postgresql.org,Patrick Molgaard
 <draaglom@gmail.com>
From: Andreas Kretschmer <andreas@a-kretschmer.de>
Message-ID: <DEC36FD8-41AD-4CDA-BC6C-72D04F12882B@a-kretschmer.de>
List-Id: <pgsql-performance.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-performance@lists.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-performance>
Precedence: bulk


>
>Intermittently (one or two times a week), all queries on that host are
>simultaneously blocked for extended periods (10s of seconds)=2E
>
>The blocked queries are trivial & not related to locking - I'm seeing
>slowlogs of the form:
>


please check if THP are enabled=2E


Regards, Andreas



--=20
2ndQuadrant - The PostgreSQL Support Company