Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1a3WRL-0004fh-O9 for pgsql-general@arkaria.postgresql.org; Mon, 30 Nov 2015 21:56:55 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1a3WRL-00045y-Af for pgsql-general@arkaria.postgresql.org; Mon, 30 Nov 2015 21:56:55 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1a3WRK-00045s-Sd for pgsql-general@postgresql.org; Mon, 30 Nov 2015 21:56:54 +0000 Received: from mout.gmx.net ([212.227.15.18]) by magus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.84) (envelope-from ) id 1a3WRH-0003qZ-UR for pgsql-general@postgresql.org; Mon, 30 Nov 2015 21:56:54 +0000 Received: from durian.home ([109.193.76.37]) by mail.gmx.com (mrgmx001) with ESMTPSA (Nemesis) id 0M0QAP-1aHtd90tC9-00ucHM; Mon, 30 Nov 2015 22:56:50 +0100 Subject: Re: Pgbouncer To: Steve Crawford References: <565CC399.4050400@gmx.net> Cc: PostgreSQL General From: =?UTF-8?Q?Torsten_F=c3=b6rtsch?= Message-ID: <565CC621.5090108@gmx.net> Date: Mon, 30 Nov 2015 22:56:49 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.3.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Provags-ID: V03:K0:FdlnDpVj3ALq4dIHlC3GLoZnTxoUgkY0zeW2M3Y27kvtvpJeqy6 Sg0LJ6KNQk3Ed6BwWgwu8OuQW4rxorYGpKywf85Mn1QLSeiSAHo3HUgKULyzmfZu+zexpku 1R5r7TKHeXnMVkR3ajpZIZJikKCJF58jVSdTU2/zlRLCMs/+4kc7XEaoBQlGRy+UtymONgR XeodzWdZn3hkHHKs2e14Q== X-UI-Out-Filterresults: notjunk:1;V01:K0:1o5N3jcUS4I=:gGsda++ugrhfbpPC9/0ARh o7ZIV6s8QVXI6hVngqsdbTdjARbTQryrC6wfk2MrtaRkkDh3wjpsbDstox5cJwG9ZY8P9NuSU BRlMYd/zRw6/AES6CHvjRrwB5YX8XMq0uQaaNmgwvKIQ5yp0AObx8lIgqE9B9lnQ2JT6yKpYr v8e4pyURGitCGXFmXSovT1JzzXW6waDp07boeYdU69waVNehKOGK7idYUoWFKLwloJ2EkU1Yt /um1u1/5yeVyUE+g9k1QIWSFoGHE5xUP36cd2uhFM8ZZsQyl8BWAtwmD9kbT/Y2fxHAuc5nuh KRdpzVkgtMH57KksRQZ5psaTxmccQ07zuJfRQI+kBlYNRQM3AZ0s8F5UMslsxD/i+k4XIXllx AU9nVl9MBcsOGs0qyeUyG4S6tGk7ri3FCR6WMkTGKx8Zx8Jagv3zDauo7ErYjFyXHGu7Sqb3P wICw6gZ1lCDA9piVc2xehEgm0RkWJeNAm3i+VZTt1dIe22yvZjCT+0Wsjm/G3NcgVqSPv+L6+ CsL0LTVgdc0DLazNkmIw3Mwmajt4WkHbuZt0lUp2qAUi+fmE7cqnDOdvA9f5rQ1+rCID2eQJB f0tpX0TdaGuQU6PHgB/Vp6YeJzLYGhPJAqoajdnpbf7TklkGnlfFlRBf2Vq5WbJLemRlgoo/r OMBIASi7kHi+jPEViy3fJt8lObfYqF+rDdBJ0CTaiJBq3qa3llJWgstS34O7hWJX0xx6hnpO6 yv1Lq24JODNlcQffeHXX6ztBg0Qoz6/3mTBv1p3L63tLuiWDJG7NjVGKw4kJ4x2l6gpHDgCha IwRCi39 X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-general Precedence: bulk Sender: pgsql-general-owner@postgresql.org On 30/11/15 22:50, Steve Crawford wrote: > Do you have any clients connected that are idle in transaction? No, the backend database is a streaming replica. Also, as I said, the backend process is in "idle" state not "idle in transaction". backend_start | 2015-11-30 18:58:30.639962+00 xact_start | query_start | 2015-11-30 20:56:36.479003+00 state_change | 2015-11-30 20:56:36.480199+00 waiting | f state | idle -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general