[ic] Performance of mysql versus postgressql

JFearn interchange-users@interchange.redhat.com
Wed Dec 12 22:05:01 2001


This link is also useful:

http://www.phpbuilder.com/columns/smith20010821.php3

Jeff.


> Check out these links:
> 
> http://www.phpbuilder.com/columns/tim20001112.php3
> http://www.phpbuilder.com/columns/tim20000705.php3
> 
> They might be a little more unbiased since they aren't published by either
> of the product providers. The best part is that the author does a good job
> of pointing out the pros and cons of each db.
> 
> 
> Mike C.
> 
> > > Also be aware that Postgres' strength lies in scalability as you load
> > your
> > > server. MySQL is quite likely to be faster under single-user or light
> > loads.
> >
> > I beg to differ. mySQL is quite likely to be faster under all
> > conditions. We run mySQL on a dozen databases anywhere from 1,000
> > records up to 2.5M records and anywhere from 10 to 100's of transactions
> > per second. All on the same machine and daemon. Most of these run from
> > various web servers with no effect on page loads. Postgres' strength
> > lies in being a "Object-Relational DBMS, supporting almost all SQL
> > constructs, including subselects, transactions, and user-defined types
> > and functions.". Because of this it is not as lean and mean as mySQL is.
> > Check out:
> > http://www.mysql.com/information/benchmark-results/result-mysql,pg.html
> >