From: | Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at> |
---|---|
To: | "'Bruce Momjian'" <pgman(at)candle(dot)pha(dot)pa(dot)us>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Philip Warner <pjw(at)rhyme(dot)com(dot)au>, Chris Bitmead <chrisb(at)nimrod(dot)itg(dot)telstra(dot)com(dot)au>, pgsql-hackers(at)postgreSQL(dot)org |
Subject: | AW: Re: [GENERAL] PostgreSQL vs. MySQL |
Date: | 2000-07-10 13:32:45 |
Message-ID: | 11C1E6749A55D411A9670001FA687963367FEA@sdexcsrv1.f000.d0188.sd.spardat.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
I do not agree. We need to keep the different databases per postmaster.
Schemas are something we need below a database. This is actually
required by SQL99. More than one database (catalog in SQL99)
is not required per SQL99, but imho a very useful feature.
We need something that allows us to access objects on another database,
but this should imho not be limited to databases on the same postmaster
(SQL99 cluster).
Andreas
From | Date | Subject | |
---|---|---|---|
Next Message | Zeugswetter Andreas SB | 2000-07-10 13:38:56 | AW: Re: postgres TODO |
Previous Message | Philip Warner | 2000-07-10 13:32:17 | Re: Re: postgres TODO |