I'm talking about connecting to multiple database servers on separate machines. Schemas don't apply here.
How much work would it take to make a pre-fork smart enough to open different databases on incoming connection? How much of it can be modeled after Apache?
I've not used it but Tatsuo Ishii has just released pgpool v1.0. Quoting from its README:
1. What is pgpool
pgpool is a connection server program for PostgreSQL. pgpool runs between PostgreSQL's client(frontend) and server(backend). Any PostgreSQL clients can connect to pgpool as if it's a real PostgreSQL server.
pgpool caches the connection to PostgreSQL server to reduce the overhead to establish the connection to it.
Also pgpool could use two PostgreSQL servers for fail over purpose. If the first server goes down, pgpool will automatically switch to the secondary server.
If that's not what you're after, then it must be fairly close. Check the mailing list archives - the download URL is on the "announce" list April 2004.
I'm sure any real figures from your testing will be of much interest to all of us.
HTH -- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
