From: Kevin Grittner <kgrittn@ymail.com>
To: Viktor Juhanson <spoon@planet.ee>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Random server overload
Date: Tue, 8 Oct 2013 08:59:59 -0700 (PDT)
Message-ID: <1381247999.63853.YahooMailNeo@web162903.mail.bf1.yahoo.com> (raw)
In-Reply-To: <1381238407.439eeaea@webmail.zone.ee>
References: <A7A2044B8A59DA4F9F07599B3B1CA1210E4CB4A7@MX101CL02.corp.emc.com>
<1381238407.439eeaea@webmail.zone.ee>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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 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 (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. 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". 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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: kgrittn@ymail.com, spoon@planet.ee
Subject: Re: Random server overload
In-Reply-To: <1381247999.63853.YahooMailNeo@web162903.mail.bf1.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox