On Sun, Dec 20, 2009 at 3:19 PM, Ron Mayer <rm_pg@xxxxxxxxxxxxxxxxxxxxxxx> wrote: > Lincoln Yeoh wrote: >> Ten or so years ago MySQL was better than Postgres95, and it would have >> been easy to justify using MySQL over Postgres95 (which was really slow >> and had a fair number of bugs). But Postgresql is much better than MySQL >> now. That's just my opinion of course. > > Really?!? > > MySQL development started in '94; and their first internal release was May 95.[1] > > At that time Postgres's SQL language support was new, but didn't the underlying > database already have a half decade of history that surely was more mature > than MySQL at the time? For a long time, postgres had a lot of issues that made it less suitable for high web environments, especially 24x7 high load. vacuum was a nightmare, transaction overhead was very high, and the complex disk format made upgrades a real pain (only this last issue remains). The postgresql optimizer has always had an edge, but it wasn't so cut and dry back then. It was only with the 8.x versions that postgres really started pulling away. merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
