Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 0C51D9FB49E for ; Fri, 30 Mar 2007 17:56:25 -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 96917-09 for ; Fri, 30 Mar 2007 17:56:17 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from globalrelay.com (mail1.globalrelay.com [204.92.49.200]) by postgresql.org (Postfix) with ESMTP id 0DF419FB46D for ; Fri, 30 Mar 2007 17:56:20 -0300 (ADT) X-Virus-Scanned: Scanned by GRC-AntiVirus Gateway X-GR-Acctd: YES X-Real-To: dingxn@cse.ohio-state.edu, pgsql-performance@postgresql.org Received: from [63.226.156.118] (HELO DaveEMachine) by globalrelay.com (CommuniGate Pro SMTP 4.2.3) with ESMTP id 134337896; Fri, 30 Mar 2007 13:56:18 -0700 From: "Dave Dutcher" To: "'Xiaoning Ding'" , Subject: Re: scalablility problem Date: Fri, 30 Mar 2007 15:56:17 -0500 Message-ID: <023401c7730d$dd0c04f0$2e00a8c0@tridecap.com> MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.6822 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 Thread-Index: AcdzDEsXFkjtr/PkRG2DrrcKCkli7AAAVygQ In-Reply-To: <460D7220.9010302@cse.ohio-state.edu> Importance: Normal X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/456 X-Sequence-Number: 23861 > From: pgsql-performance-owner@postgresql.org > [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of > Xiaoning Ding > > > Hi all, > > When I run multiple TPC-H queries (DBT3) on postgresql, I > found the system > is not scalable. My machine has 8GB memory, and 4 Xeon Dual > Core processor > ( 8 cores in total). OS kernel is linux 2.6.9. Postgresql is > 7.3.18. Is there anyway you can upgrade to 8.2? There have been a lot of performance and scalability enhancements.