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 855A29FA692; Sat, 17 Jun 2006 01:19:51 -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 29293-04; Sat, 17 Jun 2006 01:19:47 -0300 (ADT) X-Greylist: delayed 12:57:50.152956 by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- Received: from nwkea-pix-1.sun.com (nwkea-pix-1.sun.com [192.18.42.249]) by postgresql.org (Postfix) with ESMTP id 274AB9FA68D; Sat, 17 Jun 2006 01:19:46 -0300 (ADT) Received: from d1-sfbay-01.sun.com ([192.18.39.111]) by nwkea-pix-1.sun.com (8.13.6+Sun/8.12.9) with ESMTP id k5H4JfIS022134; Fri, 16 Jun 2006 21:19:41 -0700 (PDT) Received: from conversion-daemon.d1-sfbay-01.sun.com by d1-sfbay-01.sun.com (Sun Java System Messaging Server 6.2-4.02 (built Sep 9 2005)) id <0J0Z00H01G26E600@d1-sfbay-01.sun.com> (original mail from Robert.Lor@Sun.COM); Fri, 16 Jun 2006 21:19:41 -0700 (PDT) Received: from [129.150.12.121] by d1-sfbay-01.sun.com (Sun Java System Messaging Server 6.2-4.02 (built Sep 9 2005)) with ESMTPSA id <0J0Z00IDULCSRW00@d1-sfbay-01.sun.com>; Fri, 16 Jun 2006 21:19:41 -0700 (PDT) Date: Fri, 16 Jun 2006 21:17:04 -0700 From: Robert Lor Subject: Re: Sun Donated a Sun Fire T2000 to the PostgreSQL community In-reply-to: <449331EC.10207@tweakers.net> To: Arjen van der Meijden Cc: pgsql-hackers@postgresql.org, pgsql-performance@postgresql.org Message-id: <44938240.6040804@sun.com> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=us-ascii Content-transfer-encoding: 7BIT X-Accept-Language: en-us, en References: <4492CBE2.3090509@sun.com> <449331EC.10207@tweakers.net> User-Agent: Mozilla/5.0 (X11; U; SunOS i86pc; en-US; rv:1.7) Gecko/20060307 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/364 X-Sequence-Number: 19721 Arjen van der Meijden wrote: > > I can already confirm very good scalability (with our workload) on > postgresql on that machine. We've been testing a 32thread/16G-version > and it shows near-linear scaling when enabling 1, 2, 4, 6 and 8 cores > (with all four threads enabled). > > The threads are a bit less scalable, but still pretty good. Enabling > 1, 2 or 4 threads for each core yields resp 60 and 130% extra > performance. Wow, what type of workload is it? And did you do much tuning to get near-linear scalability to 32 threads? Regards, -Robert