Skip site navigation (1) Skip section navigation (2)

Re: Need help to decide Mysql vs Postgres

From: Amit V Shah <ashah(at)tagaudit(dot)com>
To: "'Joshua D(dot) Drake'" <jd(at)commandprompt(dot)com>
Cc: "'pgsql-performance(at)postgresql(dot)org'" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Need help to decide Mysql vs Postgres
Date: 2005-05-24 17:22:08
Message-ID: 0C072E7CC947D511AC9600A0CC7341200256CF04@xeon400.tagaudit.com (view raw or flat)
Thread:
Lists: pgsql-performance
Hi Josh,

Thanks for the prompt reply !! Actually migration is inevitable. We have a
totally messed up schema, not normalized and stuff like that. So the goal of
the migration is to get a new and better normalized schema. That part is
done already. Now the decision point is, should we go with postgres or
mysql. 

Thanks,
Amit
 
-----Original Message-----
From: Joshua D. Drake [mailto:jd(at)commandprompt(dot)com]
Sent: Tuesday, May 24, 2005 1:15 PM
To: Amit V Shah
Cc: 'pgsql-performance(at)postgresql(dot)org'
Subject: Re: [PERFORM] Need help to decide Mysql vs Postgres


> 
> I am not trying to start a mysql vs postgres war so please dont
> misunderstand me .... I tried to look around for mysql vs postgres
articles,
> but most of them said mysql is better in speed. However those articles
were
> very old so I dont know about recent stage. Please comment !!!

It is my experience that MySQL is faster under smaller load scenarios. 
Say 5 - 10 connections only doing simple SELECTS. E.g; a dymanic website.

It is also my experience that PostgreSQL is faster and more stable under
consistent and heavy load. I have customers you regularly are using up 
to 500 connections.

Note that alot of this depends on how your database is designed. Foreign 
keys slow things down.

I think it would be important for you to look at your overall goal of 
migration. MySQL is really not a bad product "IF" you are willing to 
work within its limitations.

PostgreSQL is a real RDMS, it is like Oracle or DB2 and comes with a 
comparable feature set. Only you can decide if that is what you need.

Sincerely,

Joshua D. Drake
Command Prompt, Inc.


-- 
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/


Responses

pgsql-performance by date

Next:From: Bruno Wolff IIIDate: 2005-05-24 17:27:13
Subject: Re: Select performance vs. mssql
Previous:From: Joshua D. DrakeDate: 2005-05-24 17:14:35
Subject: Re: Need help to decide Mysql vs Postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group