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 [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org