Re: Re: [GENERAL] PostgreSQL vs. MySQL

> Bruce Momjian wrote:
> >
> > > 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.
>
> I'm just curious, but did a consensus ever develop on schemas? It
> seemed that the schemas/tablespace thread just ran out of steam.
> For what its worth, I like the idea of:

You can find the entire thread in the current development tree in
doc/TODO.detail/tablespaces.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026