From mboxrd@z Thu Jan 1 00:00:00 1970 From: "Michael French" Subject: Re: MySQL or postgreSQL which is the best? Date: Tue, 10 Dec 2002 22:25:10 -0800 Sender: linux-admin-owner@vger.kernel.org Message-ID: <001001c2a0de$0f4e9fb0$0400a8c0@castor> References: Mime-Version: 1.0 Content-Transfer-Encoding: 7bit Return-path: List-Id: Content-Type: text/plain; charset="us-ascii" To: lisa leblanc , linux-admin@vger.kernel.org Depends on what you want to do. Are you look to do something with mostly reads and few writes, an even mix, or mostly writes? For speed, you can't beat MySQL so if you are going to be doing mostly reads (like a web site), it works great. For an application with a fair bit of writes, I would go with Postgres just because it has some more advances features and tends to scale better. I know that Postgres just released a new version 7.3 (http://www.us.postgresql.org/) recently that is supposed to be pretty slick. MySQL has also fully integrated the InnoDB code which adds truly ACID compliant transactions to MySQL as well as some other features. They are getting pretty close in features, but I would still seperate them by speed and scalability. I don't have a great deal of experience with either, but at my last job we used MySQL to run our entire web site (a newspaper) and never had any problems with it, even without the new feature set. It was mostly reads though, but very fast. I put a couple of links in below. First one is a comparison chart from a year ago. Probably changed a little bit, but will give you a good idea. Second one is a Slashdot discussion on the topic, see what others had to say. Last is the link to MySQL's site for the new 4.0 version and descriptions of the new features in the different flavors. http://phd.pp.ru/Software/SQL/PostgreSQL-vs-MySQL.html http://slashdot.org/articles/02/09/23/1652243.shtml?tid=136 Cheers, Michael French ----- Original Message ----- From: "lisa leblanc" To: Sent: Tuesday, December 10, 2002 10:00 PM Subject: MySQL or postgreSQL which is the best? > I have to choose between these databases and I do not know which is the > best. What do you think? > Lisa > > > > > > _________________________________________________________________ > The new MSN 8: smart spam protection and 2 months FREE* > http://join.msn.com/?page=features/junkmail > > - > To unsubscribe from this list: send the line "unsubscribe linux-admin" in > the body of a message to majordomo@vger.kernel.org > More majordomo info at http://vger.kernel.org/majordomo-info.html >