pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mathijs Brands <mathijs@ilse.nl>
To: pgsql-sql@postgreSQL.org
Subject: Threaded PGSQL access (was Re: [SQL] zombie postmasters)
Date: Wed, 17 Nov 1999 01:10:28 +0100
Message-ID: <19991117011028.A21454@ilse.nl> (raw)
In-Reply-To: <3831EB2F.9BD737CD@mail.montclair.edu>
References: <000201bf3087$3afadae0$810a0a0a@hamid.emarq>
	<3831EB2F.9BD737CD@mail.montclair.edu>

On Tue, Nov 16, 1999 at 06:39:27PM -0500, Stephen J Lombardo allegedly wrote:
> Depending on the programming environment you are using you may be able to
> employ a
> technique such as connection pooling/handling to seperate the actual database
> access from the program
> handling IO.  This way even if the client disconnects in the middle of a large
> query the
> connection manager can still cleanly disconnect from the database or clean up
> from the offending statement..
> 
> Utilizing a connection handler offers other benefits as well; namely it can
> eliminate the need to open
> a new database connection for every CGI process or Servlet thread.  This can
> reduce overhead by
> making it unneccesary for Postgres to start a new process for yet another
> client, and hence authenticating
> another user.

Where can I find such a connection handler? Or would I be better of writing
one myself? I need to access PostgreSQL from a custombuild scriptinglanguage
running under a threaded webserver, so I can't use libpq straight out of the
box. Such a connection handler might be the answer to my problem.

Mathijs



Message-ID: <19991117011028.A21454@ilse.nl>
Permalink:  ../19991117011028.A21454@ilse.nl/
Also on:    postgresql.org/message-id/19991117011028.A21454@ilse.nl

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: mathijs@ilse.nl
  Subject: Re: Threaded PGSQL access (was Re: [SQL] zombie postmasters)
  In-Reply-To: <19991117011028.A21454@ilse.nl>
  References: <000201bf3087$3afadae0$810a0a0a@hamid.emarq> <3831EB2F.9BD737CD@mail.montclair.edu> <19991117011028.A21454@ilse.nl>

* 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