X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 7A7D89FB2A9 for ; Sat, 29 Jul 2006 12:03:39 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 70384-06 for ; Sat, 29 Jul 2006 12:03:28 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 198399FB276 for ; Sat, 29 Jul 2006 12:03:28 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mailservice.tudelft.nl (mailservice.tudelft.nl [130.161.131.5]) by svr4.postgresql.org (Postfix) with ESMTP id 8246B5AF02E for ; Sat, 29 Jul 2006 15:03:27 +0000 (GMT) Received: from localhost (localhost [127.0.0.1]) by rav.antivirus (Postfix) with ESMTP id 6C47D22354F for ; Sat, 29 Jul 2006 17:02:59 +0200 (CEST) Received: from smtp-a.tudelft.nl (smtp-a.tudelft.nl [130.161.129.18]) by mx0.tudelft.nl (Postfix) with ESMTP id 7478F2235D3 for ; Sat, 29 Jul 2006 17:02:50 +0200 (CEST) Received: from [192.168.64.12] (bitbucket.office.oli.tudelft.nl [130.161.3.209]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by smtp-a.tudelft.nl (Postfix) with ESMTP id 3D305F1B2A for ; Sat, 29 Jul 2006 17:02:47 +0200 (CEST) Message-ID: <44CB7896.8030501@oli.tudelft.nl> Date: Sat, 29 Jul 2006 17:02:46 +0200 From: Jochem van Dieten User-Agent: Thunderbird 1.5.0.5 (Windows/20060719) MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: PostgreSQL scalability on Sun UltraSparc T1 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at tudelft.nl X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200607/278 X-Sequence-Number: 20138 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). Jochem