From: Richard Huxton <dev@archonet.com>
To: Slavisa Garic <sgaric@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: [NOVICE] Many connections lingering
Date: Wed, 13 Apr 2005 18:36:55 +0100
Message-ID: <425D58B7.5030909@archonet.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>
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.
Plenty of others have discussed the technical reasons why you are seeing
these connection issues. If you find it difficult to change your way of
working, you might find the pgpool connection-pooling project useful:
http://pgpool.projects.postgresql.org/
HTH
--
Richard Huxton
Archonet Ltd
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: dev@archonet.com, sgaric@gmail.com
Subject: Re: [NOVICE] Many connections lingering
In-Reply-To: <425D58B7.5030909@archonet.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