> And of course the major problem with *that* is how do you get the
> connection request to arrive at a backend that's been prestarted in
> the right database? If you don't commit to a database then there's
> not a whole lot of prestarting that can be done.
>
> It occurs to me that this'd get a whole lot more feasible if one
> postmaster == one database, which is something we *could* do if we
> implemented schemas. Hiroshi's been arguing that the current hard
> separation between databases in an installation should be done away
> with in favor of schemas, and I'm starting to see his point...
This is interesting. You believe schema's would allow a pool of
backends to connect to any database? That would clearly be a win.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026