Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 7A8CB633DD1 for ; Wed, 18 Mar 2009 08:36:29 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 38173-10 for ; Wed, 18 Mar 2009 08:36:20 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from exprod7og115.obsmtp.com (exprod7og115.obsmtp.com [64.18.2.217]) by mail.postgresql.org (Postfix) with SMTP id 8BB33633203 for ; Wed, 18 Mar 2009 08:36:25 -0300 (ADT) Received: from source ([74.125.78.24]) by exprod7ob115.postini.com ([64.18.6.12]) with SMTP ID DSNKScDctuHFyMA0zwo63As5e+QzftUPxbEn@postini.com; Wed, 18 Mar 2009 04:36:25 PDT Received: by ey-out-2122.google.com with SMTP id 22so947eye.51 for ; Wed, 18 Mar 2009 04:36:22 -0700 (PDT) Received: by 10.216.54.198 with SMTP id i48mr100516wec.144.1237376182038; Wed, 18 Mar 2009 04:36:22 -0700 (PDT) Received: from oxford.xeocode.com.enterprisedb.com ([82.16.16.210]) by mx.google.com with ESMTPS id g17sm63991nfd.32.2009.03.18.04.36.20 (version=TLSv1/SSLv3 cipher=RC4-MD5); Wed, 18 Mar 2009 04:36:21 -0700 (PDT) To: "Jignesh K. Shah" Cc: Simon Riggs , Tom Lane , Kevin Grittner , pgsql-performance@postgresql.org Subject: Re: Proposal of tunable fix for scalability of 8.4 In-Reply-To: <49C0384E.2020707@sun.com> (Jignesh K. Shah's message of "Tue\, 17 Mar 2009 19\:54\:54 -0400") User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.1 (gnu/linux) X-Draft-From: ("nnimap+imap.gmail.com:PG" 113514) References: <49B824DD.7090302@sun.com> <49B7F470.EE98.0025.0@wicourts.gov> <29080.1236821556@sss.pgh.pa.us> <49B87161.10201@sun.com> <1237225198.3963.60.camel@ebony.2ndQuadrant> <49C01900.5030406@sun.com> <1237330778.3953.139.camel@ebony.2ndQuadrant> <49C0384E.2020707@sun.com> From: Gregory Stark Organization: EnterpriseDB Date: Wed, 18 Mar 2009 11:36:18 +0000 Message-ID: <87iqm7f4gd.fsf@oxford.xeocode.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200903/244 X-Sequence-Number: 33166 "Jignesh K. Shah" writes: > In next couple of weeks I plan to test the patch on a different x64 based > system to do a sanity testing on lower number of cores and also try out other > workloads ... I'm actually more interested in the large number of cores but fewer processes and lower max_connections. If you set max_connections to 64 and eliminate the wait time you should, in theory, be able to get 100% cpu usage. It would be very interesting to track down the contention which is preventing that. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS support!