pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (10+ messages)  latest in thread

Message-ID: <425D58B7.5030909@archonet.com>
Permalink:  ../425D58B7.5030909@archonet.com/
Also on:    postgresql.org/message-id/425D58B7.5030909@archonet.com

 · 

reply

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