Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 2E5269FB5E8 for ; Fri, 30 Mar 2007 18:44:45 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 04775-02 for ; Fri, 30 Mar 2007 18:44:37 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from exchange.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by postgresql.org (Postfix) with ESMTP id 96B279FB5FB for ; Fri, 30 Mar 2007 18:44:41 -0300 (ADT) Received: from 10.10.1.37 ([10.10.1.37]) by exchange.g2switchworks.com ([10.10.1.2]) with Microsoft Exchange Server HTTP-DAV ; Fri, 30 Mar 2007 21:44:39 +0000 Received: from state.g2switchworks.com by mail.g2switchworks.com; 30 Mar 2007 16:44:39 -0500 Subject: Re: scalablility problem From: Scott Marlowe To: Xiaoning Ding Cc: pgsql-performance@postgresql.org In-Reply-To: <460D8371.7080405@cse.ohio-state.edu> References: <460D7220.9010302@cse.ohio-state.edu> <23586.1175289138@sss.pgh.pa.us> <460D8371.7080405@cse.ohio-state.edu> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1175291079.25022.114.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Fri, 30 Mar 2007 16:44:39 -0500 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/460 X-Sequence-Number: 23865 On Fri, 2007-03-30 at 16:38, Xiaoning Ding wrote: > Thanks guys, > > I update PG to 8.2.3. The results are much better now. > 1 process : 0.94 second > 2 processes: 1.32 seconds > 4 processes: 2.03 seconds > 8 processes: 2.54 seconds > > Do you think they are good enough? > BTW where can I found some info on what 8.2.3 did to improve > scalability compared with pre 8.1 versions? Very nice, eh? I'd say look through -hackers and -perform to see some of it, but as usual, the source code is the reference. You'd be surprised how well commented it is.