Subject: Re: Differences between Postgresql and mysql
From: Rob Brandt (rbrandt@sbdsl.com)
Date: Tue Oct 09 2001 - 10:57:47 MDT
My understanding was that the big difference was lack of transaction
management in MySQL - no rollbacks. Which sometimes matters, and
sometimes not.
Rob
>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 - 10:09:07 MDT