On 7/29/06, Jochem van Dieten <jochemd@oli.tudelft.nl> wrote:
> Tweakers.net has done a database performance test between a Sun T2000 (8
> core T1) and a Sun X4200 (2 dual core Opteron 280). The database
> benchmark is developed inhouse and represents the average query pattern
> from their website. It is MySQL centric because Tweakers.net runs on
> MySQL, but Arjen van der Meijden has ported it to PostgreSQL and has
> done basic optimizations like adding indexes.
anandtech did a comparison of opteron/xeon/sun t1 not to long ago and
published some mysql/postgresql results. however, they were careful
not to publish the quad core data for pg to compare vs. mysql, which
in my opinion would have shown a blowout victory for pg. (also was pg
8.0).
the fact is, postgresql is often faster than mysql under real
workloads, especially when utilizing features such as stored
procedures and such.
merlin