Pooled postgresql backends

From: Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Pooled postgresql backends
Date: 1999-12-09 04:37:37
Message-ID: 99120823453803.01570@lorc.wgcr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Browse pgsql-hackers by date

  From Date Subject
Next Message Lamar Owen 1999-12-09 04:47:08 PostgreSQL front ends (was Re: [HACKERS] Parallel regress tests (was Re: FOREIGN KEY andshift/reduce))
Previous Message Don Baccus 1999-12-09 04:30:30 Re: [HACKERS] Parallel regress tests (was Re: FOREIGN KEY andshift/reduce)