DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=ymail.com;
 h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
 b=Trw1AS+dPD3eXjaOYbQYoM2kKw39rt4eNoPGyM6VTr5USiZxHh5rhMPuKnS99ME0iX4qnk1FZ5PT6y0UAA+3cp1T5Geg6tqNRy9zzfX73/qTIOx0cYHz0/oEJ4uf6ye1CyJjVMajBRBqr9yqrR/OOF5JQgyHzX+eXpnkQVdKFus=;
References: <A7A2044B8A59DA4F9F07599B3B1CA1210E4CB4A7@MX101CL02.corp.emc.com>
 <1381238407.439eeaea@webmail.zone.ee>
Message-ID: <1381247999.63853.YahooMailNeo@web162903.mail.bf1.yahoo.com>
Date: Tue, 8 Oct 2013 08:59:59 -0700 (PDT)
From: Kevin Grittner <kgrittn@ymail.com>
Reply-To: Kevin Grittner <kgrittn@ymail.com>
Subject: Re: Random server overload
To: Viktor Juhanson <spoon@planet.ee>,
 "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
In-Reply-To: <1381238407.439eeaea@webmail.zone.ee>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Viktor Juhanson <spoon@planet.ee> wrote:

> Btw we have the max pool size of web application 50 connections
> and since we have 4 instances of application running=A0 it makes
> max 200.
>
> 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 ?

If the client application=A0 (or pooler) doesn't close the database
connections gracefully, it might take some time before the server
figures out the connection is dead and frees the resources on the
server side.=A0 Does the server log say anything about broken
connections or client not responding?

Also, the pooler might maintanin some *minimum* number of
connections but go beyond that "on demand".=A0 Without knowing what
pooler and how it is configured, it's hard to say what might be
going on.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin