Thread: time sensitve: comparing performance to MySQL

time sensitve: comparing performance to MySQL

From
Mark Stosberg
Date:
Hello,

I've been tasked to do some quick research on Postgres vs. MySQL that I
need to present later today. I've already done a lot of Googlin' and
reviewing of the Postgres websites.

The project at hand will be a  high-volume website with many complex
queries. It will likely use replication. Performance will be most
important for SELECT statements.

The project will be ported form an existing codebase which uses Oracle
as the backend.

I understand that Postgres has been closing the speed gap with MySQL,
but I'm having trouble finding hard data on this. What specific
information is available in this area?

Your help is appreciated!

    Mark

--
 . . . . . . . . . . . . . . . . . . . . . . . . . . .
   Mark Stosberg            Principal Developer
   mark@summersault.com     Summersault, LLC
   765-939-9301 ext 202     database driven websites
 . . . . . http://www.summersault.com/ . . . . . . . .

Re: time sensitve: comparing performance to MySQL

From
Ryan Mahoney
Date:
On Thu, 2003-10-02 at 12:17, Mark Stosberg wrote:
> I understand that Postgres has been closing the speed gap with MySQL,
> but I'm having trouble finding hard data on this.

The "speed gap" you speek of is a myth, try to find some hard data on
that!  The cases where mysql can really fly are not generally the
application scenarios you encounter in the real world unless you are
working with a read-high/write-low cases.  Unfortunately, without
porting your app to both dbs you can not verify this experientially.
You could easily create an app to stress test both dbs (creating a php
script with a few queries from your app) and hit it with apache bench to
simulate your load.

We have been using postgres since 2000 for some relatively complex
e-commerce and order management projects.  We used mysql for about a
week because we weren't familiar with postgres and we bought into the
mysql hype.  But coming from Oracle and MSSQL, mysql was a total joke
and didn't have the features to support our application so we had to
disqualify it before we could even bench it.  Postgres is a pleasure,
especially if you are coming from an Oracle environment.

-r