From: Mark Lewis <mark.lewis@mir3.com>
To: Slavisa Garic <sgaric@gmail.com>
Cc: Greg Stark <gsstark@mit.edu>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Cc: pgsql-novice@postgresql.org
Subject: Re: [PERFORM] Many connections lingering
Date: Wed, 13 Apr 2005 09:42:29 -0700
Message-ID: <1113410549.5589.62.camel@amateljan.mirlogic.com> (raw)
In-Reply-To: <bcb55890050412220936c80013@mail.gmail.com>
References: <bcb55890050412192911e953c@mail.gmail.com>
<2314.1113360715@sss.pgh.pa.us>
<87u0mbjr02.fsf@stark.xeocode.com>
<bcb55890050412220936c80013@mail.gmail.com>
If there are potentially hundreds of clients at a time, then you may be
running into the maximum connection limit.
In postgresql.conf, there is a max_connections setting which IIRC
defaults to 100. If you try to open more concurrent connections to the
backend than that, you will get a connection refused.
If your DB is fairly gnarly and your performance needs are minimal it
should be safe to increase max_connections. An alternative approach
would be to add some kind of database broker program. Instead of each
agent connecting directly to the database, they could pass their data to
a broker, which could then implement connection pooling.
-- Mark Lewis
On Tue, 2005-04-12 at 22:09, Slavisa Garic wrote:
> This is a serious problem for me as there are multiple users using our
> software on our server and I would want to avoid having connections
> open for a long time. In the scenario mentioned below I haven't
> explained the magnitute of the communications happening between Agents
> and DBServer. There could possibly be 100 or more Agents per
> experiment, per user running on remote machines at the same time,
> hence we need short transactions/pgsql connections. Agents need a
> reliable connection because failure to connect could mean a loss of
> computation results that were gathered over long periods of time.
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-performance@postgresql.org
Cc: mark.lewis@mir3.com, sgaric@gmail.com, gsstark@mit.edu, tgl@sss.pgh.pa.us, pgsql-novice@postgresql.org
Subject: Re: [PERFORM] Many connections lingering
In-Reply-To: <1113410549.5589.62.camel@amateljan.mirlogic.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