Re: Need help to decide Mysql vs Postgres

From: Amit V Shah <ashah(at)tagaudit(dot)com>
To: 'Jeffrey Tenny' <jeffrey(dot)tenny(at)comcast(dot)net>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Need help to decide Mysql vs Postgres
Date: 2005-06-06 16:00:08
Message-ID: 0C072E7CC947D511AC9600A0CC7341200256CF36@xeon400.tagaudit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi all,

Thanks for your replies.

I ran a very prelimnary test, and found following results. I feel they are
wierd and I dont know what I am doing wrong !!!

I made a schema with 5 tables. I have a master data table with foreign keys
pointing to other 4 tables. Master data table has around 4 million records.
When I run a select joining it with the baby tables,

postgres -> returns results in 2.8 seconds
mysql -> takes around 16 seconds !!!! (This is with myisam ... with innodb
it takes 220 seconds)

I am all for postgres at this point, however just want to know why I am
getting opposite results !!! Both DBs are on the same machine

Thanks,
Amit

-----Original Message-----
From: Jeffrey Tenny [mailto:jeffrey(dot)tenny(at)comcast(dot)net]
Sent: Monday, June 06, 2005 11:51 AM
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] Need help to decide Mysql vs Postgres

Re: your JDBC wishes: Consider IBM Cloudscape (now Apache Derby) too,
which has an apache license. It's all pure java and it's easy to get going.

As to MySql vs Postgres: license issues aside, if you have
transactionally complex needs (multi-table updates, etc), PostgreSQL
wins hands down in my experience. There are a bunch of things about
MySQL that just suck for high end SQL needs. (I like my subqueries,
and I absolutely demand transactional integrity).

There are some pitfalls to pgsql though, especially for existing SQL
code using MAX and some other things which can really be blindsided
(performance-wise) by pgsql if you don't use the workarounds.

MySQL is nice for what I call "raw read speed" applications. But that
license is an issue for me, as it is for you apparently.

Some cloudscape info:
http://www-306.ibm.com/software/data/cloudscape/

Some info on pitfalls of MySQL and PostgreSQL, an interesting contrast:
http://sql-info.de/postgresql/postgres-gotchas.html
http://sql-info.de/mysql/gotchas.html

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Casey Allen Shobe 2005-06-06 16:04:39 Re: Performance nightmare with dspam (urgent) (resolved)
Previous Message John A Meinel 2005-06-06 15:52:09 Re: Performance nightmare with dspam (urgent) (resolved)