real-world postgresql vs mysql benchmark

Previous | Next

By pcx99
via hackmap.blogspot.com
Published: Jan 31 2007 / 11:16

At my work, we have a large MySQL database (15 MyISAM tables, 21 million rows, 10Gigs size). After seeing the benchmarks showing that Postgres out-performs MySQL on multi-core machines (our new db server has 4 CPU's), I ported the database to PostgreSQL.

Vote up

Vote down

14
0
1307
594

Tweet Save Send Tags: database, opinion

Upcoming Links

See all the newest links

Comments

Add your comment

pcx99 replied ago:

0 votes

Bottom line: The script consistently runs in 45 seconds on MySQL and in 29-31 seconds in Postgres. Other scripts seem to have about that difference--PostgreSQL finishes in about 60-70% of the time that the MySQL scripts do. Or, more dramatically: MySQL is 50% slower. That's pretty good for no change in the API, and all tables have the same indexing and structure.

PS, I did add tags but I got a pretty impressive error message when I submitted this so I guess something (besides the screen shot and my original "submission vote") got lost in the translation. I'm really surprised it got submitted at all.