Message-ID: <44CB8235.9070903@commandprompt.com>
Date: Sat, 29 Jul 2006 08:43:49 -0700
From: "Joshua D. Drake" <jd@commandprompt.com>
Organization: Command Prompt, Inc.
User-Agent: Thunderbird 1.5.0.4 (X11/20060615)
MIME-Version: 1.0
To: Jochem van Dieten <jochemd@oli.tudelft.nl>
CC: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL scalability on Sun UltraSparc T1
References: <44CB7896.8030501@oli.tudelft.nl>
In-Reply-To: <44CB7896.8030501@oli.tudelft.nl>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Jochem van Dieten 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.
> 
> Arjen wrote about some of the preliminary results previously in
> http://archives.postgresql.org/pgsql-performance/2006-06/msg00358.php
> but the article has now been published http://tweakers.net/reviews/633/7
> This is all the more impressive if you scroll down and look at the
> behaviour of MySQL (after tweaking by both MySQL AB and Sun).

I would love to get my hands on that postgresql version and see how much 
farther it could be optimized.

Joshua D. Drake


> 
> Jochem
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
> 


-- 

    === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
    Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/