Re: Why is MySQL more chosen over PostgreSQL?

From: Curt Sampson <cjs(at)cynic(dot)net>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: "Roderick A(dot) Anderson" <raanders(at)acm(dot)org>, <cbbrowne(at)cbbrowne(dot)com>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Why is MySQL more chosen over PostgreSQL?
Date: 2002-07-29 17:01:19
Message-ID: Pine.NEB.4.44.0207300145550.457-100000@angelic.cynic.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, 29 Jul 2002, Bruce Momjian wrote:

> Curt Sampson wrote:
> > I'm still waiting to find out just what advantage table inheritance
> > offers. I've asked a couple of times here, and nobody has even started
> > to come up with anything.
>
> We inherited inheritance from Berkeley. I doubt we would have added it
> ourselves. It causes too much complexity in other parts of the system.

Ah, all the more reason to remove it, then! :-)

But really, please don't take that as a criticism of the current development
direction; I know it was inherited, and it's not new code. In fact, I think
it probably wasn't until _The Third Manifsto_ came out in 1998 that it
really became clear that table inheritance was not terribly useful--if it's
even generally known now. And even so, I'm open to other opinions on that,
since it's not been an intensive area of study by any means.

> > All that said, though, don't take this as any kind of a dismissal of
> > postgres. It's in most ways better than MySQL and also some commericial
> > systems, and many of its failures are being addressed. Postgres for some
> > reason seems to attract some really, really smart people to work on it.
> > If I could see something better, I'd be there. But I don't.
>
> Interbase/Firebird maybe? They just came out with a 1.0 release in March.

Once in a while I go back to it, but I still can't build the darn thing
from scratch. Which makes it a bit difficult to evaluate....

> As for why PostgreSQL is less popular than MySQL, I think it is all
> momentum from 1996 when MySQL worked and we sometimes crashed.

Right. I have a lot of hope. After all, MySQL was for a couple of
years a second-runner to mSQL, remember?

cjs
--
Curt Sampson <cjs(at)cynic(dot)net> +81 90 7737 2974 http://www.netbsd.org
Don't you know, in this new Dark Age, we're all light. --XTC

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Luis Alberto Amigo Navarro 2002-07-29 18:21:27 Re: question on backends
Previous Message Mike Mascari 2002-07-29 16:49:29 Re: Why is MySQL more chosen over PostgreSQL?