Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id E4DFA9FB544 for ; Sat, 31 Mar 2007 12:49:06 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 91942-01 for ; Sat, 31 Mar 2007 12:49:03 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from lists.commandprompt.com (host-254.commandprompt.net [207.173.203.254]) by postgresql.org (Postfix) with ESMTP id BAE119FB46D for ; Sat, 31 Mar 2007 12:49:03 -0300 (ADT) Received: from [192.168.1.50] (or-67-76-146-141.sta.embarqhsd.net [67.76.146.141]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id l2VFn0GL018827 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Sat, 31 Mar 2007 08:49:01 -0700 Message-ID: <460E82ED.8070106@commandprompt.com> Date: Sat, 31 Mar 2007 08:49:01 -0700 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Thunderbird 1.5.0.10 (X11/20070306) MIME-Version: 1.0 To: Xiaoning Ding CC: Scott Marlowe , pgsql-performance@postgresql.org Subject: Re: scalablility problem References: <460D7220.9010302@cse.ohio-state.edu> <1175290903.25022.110.camel@state.g2switchworks.com> <460E8198.1010604@cse.ohio-state.edu> In-Reply-To: <460E8198.1010604@cse.ohio-state.edu> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV 0.88.5/2865/Sun Mar 18 08:27:48 2007 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Sat, 31 Mar 2007 08:49:01 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/466 X-Sequence-Number: 23871 >> pgsql 7.3 cannot take advantage of lots of shared memory, and has some >> issues scaling to lots of CPUs / processes. > > I use RHEL 4. I can not understand how the scalability related with > shared memory? It isn't RHEL4 and shared memory. It is PostgreSQL and shared memory. Things have changed with PostgreSQL since 7.3 (7.3 is really god awful old) that allow it to more effectively access shared memory and thus provide better performance. Joshua D. Drake -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/