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.
> 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.
As for why PostgreSQL is less popular than MySQL, I think it is all
momentum from 1996 when MySQL worked and we sometimes crashed. Looking
forward, I don't know many people who choose MySQL _if_ they consider
both PostgreSQL and MySQL, so the discussions people have over MySQL vs.
PostgreSQL are valuable because they get people to consider MySQL
alternatives, and once they do, they usually choose PostgreSQL.
As for momentum, we still have a smaller userbase than MySQL, but we are
increasing our userbase at a fast rate, perhaps faster than MySQL at
this point.
-- 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