Re: Re: [GENERAL] PostgreSQL vs. MySQL

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: 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" <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: Re: [GENERAL] PostgreSQL vs. MySQL
Date: 2000-07-10 13:10:09
Message-ID: 200007101310.JAA26260@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general 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(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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Keller 2000-07-10 13:13:21 Re: Problems installing pltcl
Previous Message Travis Bauer 2000-07-10 13:07:20 Re: [NOVICE] newbie problem on creating table

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2000-07-10 13:11:48 Re: more corruption
Previous Message Tim Perdue 2000-07-10 13:09:22 Re: AW: more corruption