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 6F3C19FA6B4; Fri, 16 Jun 2006 19:34:26 -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 93604-01; Fri, 16 Jun 2006 19:34:17 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- 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 AA1359FA5D8; Fri, 16 Jun 2006 19:34:17 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from olive.qinip.net (olive.qinip.net [62.100.30.40]) by svr4.postgresql.org (Postfix) with ESMTP id B65DC5AF02A; Fri, 16 Jun 2006 22:34:16 +0000 (GMT) Received: from [127.0.0.1] (h8441139206.dsl.speedlinq.nl [84.41.139.206]) by olive.qinip.net (Postfix) with ESMTP id 49C2E18111; Sat, 17 Jun 2006 00:34:13 +0200 (MEST) Message-ID: <449331EC.10207@tweakers.net> Date: Sat, 17 Jun 2006 00:34:20 +0200 From: Arjen van der Meijden User-Agent: Thunderbird 1.5.0.4 (Windows/20060516) MIME-Version: 1.0 To: Robert Lor Cc: pgsql-hackers@postgresql.org, pgsql-performance@postgresql.org Subject: Re: Sun Donated a Sun Fire T2000 to the PostgreSQL community References: <4492CBE2.3090509@sun.com> In-Reply-To: <4492CBE2.3090509@sun.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Antivirus: avast! (VPS 0624-2, 15-06-2006), Outbound message X-Antivirus-Status: Clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/359 X-Sequence-Number: 19716 On 16-6-2006 17:18, Robert Lor wrote: > > I think this system is well suited for PG scalability testing, among > others. We did an informal test using an internal OLTP benchmark and > noticed that PG can scale to around 8 CPUs. Would be really cool if all > 32 virtual CPUs can be utilized!!! 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. Best regards, Arjen