Subject: Re: Differences between Postgresql and mysql
From: Kit Plummer (kp@yak.vme.com)
Date: Tue Oct 09 2001 - 10:09:59 MDT
I agree, I am not against PostgreSQL in anyway. But, to argue for MySQL
there is a special release which supports advanced table formats. In
addition, there are patches available which provide table locking and
special join functionality - which seemed to be the big argument for
PostgreSQL at one point.
Having used both databases in production environments I still would suggest
MySQL...
Kit
At 11:55 AM 10/9/2001 -0400, you wrote:
>On Tue, 9 Oct 2001, Kit Plummer wrote:
> >My suggestion is that if you have any intention what so ever of putting
> >your database on the Inet then MySQL is your choice. The speed of MySQL
> >is a high requisite for any web-based transaction.
>
>
> I really can't agree with this. We have chosen PostgreSQL for our
>database and we easily get several thousand queries a day (some of our
>pages have over 100 queries on them). PostgreSQL is hands down a more
>robust and complete database than MySQL. It passes the ACID test, has
>support for triggers and its own scripting language (as well as Perl).
>Some have stated that PostgreSQL is slower than MySQL, but honestly we
>haven't noticed much of a difference. We have been using PostgreSQL since
>version 7.0, and I have heard that version 6.5 was a dog performance-wise,
>so maybe some of the complaints were from earlier versions.
>
> So, my advice would be if you need speedy, read-only access but robust or
>feature rich is not important, then go with MySQL. Otherwise go with
>PostgreSQL, it really isn't hard to learn at all.
>
>Cheers,
>
>Chris
>
>
>--
>
>Christopher Murtagh
>Webmaster / Sysadmin
>Web Communications Group
>McGill University
>Montreal, Quebec
>Canada
>
>Tel.: (514) 398-3122
>Fax: (514) 398-2017
>
This archive was generated by hypermail 2a24 : Tue Oct 09 2001 - 09:18:26 MDT