From: Slavisa Garic <sgaric@gmail.com>
To: Richard Huxton <dev@archonet.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: [NOVICE] Many connections lingering
Date: Thu, 14 Apr 2005 11:11:51 +1000
Message-ID: <bcb55890050413181115692c75@mail.gmail.com> (raw)
In-Reply-To: <425D58B7.5030909@archonet.com>
References: <bcb55890050412192911e953c@mail.gmail.com>
<2314.1113360715@sss.pgh.pa.us>
<87u0mbjr02.fsf@stark.xeocode.com>
<bcb55890050412220936c80013@mail.gmail.com>
<425D58B7.5030909@archonet.com>
Hi,
This looks very interesting. I'll give it a better look and see if the
performance penalties pgpool brings are not substantial in which case
this program could be very helpful,
Thanks for the hint,
Slavisa
On 4/14/05, Richard Huxton <dev@archonet.com> wrote:
> 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: sgaric@gmail.com, dev@archonet.com
Subject: Re: [NOVICE] Many connections lingering
In-Reply-To: <bcb55890050413181115692c75@mail.gmail.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