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 5199E9FB2B6 for ; Tue, 1 Aug 2006 14:26:34 -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 75315-06 for ; Tue, 1 Aug 2006 14:26:24 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 4A9CB9FA64B for ; Tue, 1 Aug 2006 14:26:23 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 1CF8D56435; Tue, 1 Aug 2006 12:26:19 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Tue, 1 Aug 2006 12:26:17 -0500 Date: Tue, 1 Aug 2006 12:26:17 -0500 From: "Jim C. Nasby" To: "Joshua D. Drake" Cc: Jochem van Dieten , pgsql-performance@postgresql.org Subject: Re: PostgreSQL scalability on Sun UltraSparc T1 Message-ID: <20060801172617.GN40481@pervasive.com> References: <44CB7896.8030501@oli.tudelft.nl> <44CB8235.9070903@commandprompt.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <44CB8235.9070903@commandprompt.com> X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060801:jd@commandprompt.com::AFOM2IyAp90SAIO5:00000000000000000 0000000000000000000000005cRe X-Hashcash: 1:20:060801:jochemd@oli.tudelft.nl::+mIumHTv+/TMPYTT:000000000000000 0000000000000000000000005RFD X-Hashcash: 1:20:060801:pgsql-performance@postgresql.org::kktPgrXuEIbedTIT:00000 0000000000000000000000002TCU X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.066 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200608/9 X-Sequence-Number: 20194 On Sat, Jul 29, 2006 at 08:43:49AM -0700, Joshua D. Drake wrote: > 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. I'd love to get an english translation that we could use for PR. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461