RE: [HACKERS] Pooled postgresql backends

There's a small connection pool manager class for JDBC in the
src/interfaces/jdbc/example/corba directory. Ok, it doesn't implement
the FE-BE protocol, but does hand out already open Connections.

It's simple, but it works.

Peter

--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council.

-----Original Message-----
From: Lamar Owen [mailto:lamar(dot)owen(at)wgcr(dot)org]
Sent: Thursday, December 09, 1999 4:38 AM
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: [HACKERS] Pooled postgresql backends

Ok, I just had a brainstorm for those who want to get a pooling-capable
postmaster up and running.

Do the following:

1.) Grab the GPL'd AOLserver 3.0 from aolserver.lcs.mit.edu
2.) Strip out the webserver stuff.
3.) Write a communications module for AOLserver that implements the
PostgreSQL FE-BE protocol.
4.) That module then redirects said communications to a backend
under the pool.
5.) Of course, the real postmaster has to run on a different port,
as the
AOLserver database driver still will need to initiate connections
through
postmaster.
6.) A few other minor issues will need to be handled, such as
multi-database enabling the AOLserver pool mechanism.

Advantages: AOLserver is multithreaded -- this thing could be made quite
fast,
with low latency.

Disadvantages: Adds yet another layer of communication, unless some
really
creative coding can be done, thus, post-connect throughput is likely to
suffer.
AOLserver is GPL'd, so code lifted from it could not be integrated into
the main
PostgreSQL tree.

For those who think they need pooled connections and are not already
running
AOLServer...

--
Lamar Owen
WGCR Internet Radio

************