Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M41730=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1VTXCu-0000nN-NI
 for pgsql-admin@arkaria.postgresql.org; Tue, 08 Oct 2013 13:20:12 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M41730=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1VTXCu-00028f-7X
 for pgsql-admin@arkaria.postgresql.org; Tue, 08 Oct 2013 13:20:12 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <spoon@planet.ee>) id 1VTXCt-00027m-F0
 for pgsql-admin@postgresql.org; Tue, 08 Oct 2013 13:20:11 +0000
Received: from webmail.zone.eu ([217.146.65.70])
 by magus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <spoon@planet.ee>) id 1VTXCq-0007j0-VN
 for pgsql-admin@postgresql.org; Tue, 08 Oct 2013 13:20:11 +0000
Received: from webmail.zone.ee (webmail.zone.eu [IPv6:2a02:29e8:700:0:1::70])
 by webmail.zone.eu (Postfix) with ESMTPA id B81E82401F6D
 for <pgsql-admin@postgresql.org>; Tue,  8 Oct 2013 16:20:07 +0300 (EEST)
Received: from [195.222.11.180] (Authenticated sender: spoon@planet.ee)
 by webmail.zone.ee ([217.146.65.71]) with HTTP;
 Tue, 08 Oct 2013 16:20:07 +0300 (EEST)
From: "Viktor Juhanson" <spoon@planet.ee>
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: Random server overload
Date: Tue, 08 Oct 2013 16:20:07 +0300
References: <A7A2044B8A59DA4F9F07599B3B1CA1210E4CB4A7@MX101CL02.corp.emc.com>
In-Reply-To: <A7A2044B8A59DA4F9F07599B3B1CA1210E4CB4A7@MX101CL02.corp.emc.com>
X-Mailer: DataZone Webmail/2.4
X-Priority: 3
Message-ID: <1381238407.439eeaea@webmail.zone.ee>
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="--=_271df780c0c704957c9dda034e2692c4"
X-Pg-Spam-Score: 0.0 (/)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

----=_271df780c0c704957c9dda034e2692c4
Content-Type: text/plain;
	charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hello,
=20
 It's me again..
=20
 Log_connection inspection didn't help to find the cause, the connections =
come from our app-servers as usual..
=20
 Btw we have the max pool size of web application 50 connections and since =
we have 4 instances of application running=C2=A0 it makes max 200.
=20
 I don't really get how the database pool gets full when application can =
use 200 connections max and postrgesql config has set to 250 max =
connections ?=20
=20
 Autovacuum and master-slave replication shouldn't use many connections =
also.
=20
 Please explain that, maybe i'm missing something.
=20
 Should we try to reduce this limit to 40 per application?
=20


----=_271df780c0c704957c9dda034e2692c4
Content-Type: text/html;
	charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hello,<br />
<br />
It's me again..<br />
<br />
Log_connection inspection didn't help to find the cause, the connections =
come from our app-servers as usual..<br />
<br />
Btw we have the max pool size of web application 50 connections and since =
we have 4 instances of application running&#160; it makes max 200.<br />
<br />
I don't really get how the database pool gets full when application can =
use 200 connections max and postrgesql config has set to 250 max =
connections ? <br />
<br />
Autovacuum and master-slave replication shouldn't use many connections =
also.<br />
<br />
Please explain that, maybe i'm missing something.<br />
<br />
Should we try to reduce this limit to 40 per application?<br />
<br />

----=_271df780c0c704957c9dda034e2692c4--