Re: Re: [GENERAL] PostgreSQL vs. MySQL - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Re: [GENERAL] PostgreSQL vs. MySQL
Date
Msg-id 200007101310.JAA26260@candle.pha.pa.us
Whole thread Raw
In response to Re: Re: [GENERAL] PostgreSQL vs. MySQL  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Re: [GENERAL] PostgreSQL vs. MySQL  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> 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
 


pgsql-hackers by date:

Previous
From: Tim Perdue
Date:
Subject: Re: AW: more corruption
Next
From: Bruce Momjian
Date:
Subject: Re: more corruption