Re: PostgreSQL scalability on Sun UltraSparc T1 - Mailing list pgsql-performance

From Merlin Moncure
Subject Re: PostgreSQL scalability on Sun UltraSparc T1
Date
Msg-id b42b73150607310904w4e52e3d7oac5fe0d63ac16bc1@mail.gmail.com
Whole thread Raw
In response to PostgreSQL scalability on Sun UltraSparc T1  (Jochem van Dieten <jochemd@oli.tudelft.nl>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Axel Rau
Date:
Subject: Re: directory tree query with big planner variation
Next
From: H Hale
Date:
Subject: Re: sub select performance due to seq scans