Received: from serv0.ilse.net (serv0.ilse.nl [194.158.182.236]) by hub.org (8.9.3/8.9.3) with ESMTP id TAA18210 for ; Tue, 16 Nov 1999 19:10:38 -0500 (EST) (envelope-from mathijs@ilse.nl) Received: (from mathijs@localhost) by serv0.ilse.net (8.8.8/8.6.12) id BAA21593 for pgsql-sql@postgreSQL.org; Wed, 17 Nov 1999 01:10:28 +0100 (MET) Date: Wed, 17 Nov 1999 01:10:28 +0100 From: Mathijs Brands To: pgsql-sql@postgreSQL.org Subject: Threaded PGSQL access (was Re: [SQL] zombie postmasters) Message-ID: <19991117011028.A21454@ilse.nl> References: <000201bf3087$3afadae0$810a0a0a@hamid.emarq> <3831EB2F.9BD737CD@mail.montclair.edu> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 1.0pre4i In-Reply-To: <3831EB2F.9BD737CD@mail.montclair.edu>; from LombardoS@Mail.Montclair.edu on Tue, Nov 16, 1999 at 06:39:27PM -0500 X-Unexpected-Header: The Spanish Inquisition 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