Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 845DF9F93E4 for ; Fri, 30 Mar 2007 18:12:28 -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 10041-04 for ; Fri, 30 Mar 2007 18:12:23 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 751E89FB4F0 for ; Fri, 30 Mar 2007 18:12:24 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id l2ULCIn6023587; Fri, 30 Mar 2007 17:12:18 -0400 (EDT) To: Xiaoning Ding cc: pgsql-performance@postgresql.org Subject: Re: scalablility problem In-reply-to: <460D7220.9010302@cse.ohio-state.edu> References: <460D7220.9010302@cse.ohio-state.edu> Comments: In-reply-to Xiaoning Ding message dated "Fri, 30 Mar 2007 16:25:04 -0400" Date: Fri, 30 Mar 2007 17:12:18 -0400 Message-ID: <23586.1175289138@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/457 X-Sequence-Number: 23862 Xiaoning Ding writes: > 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. If you are not running PG 8.1 or later, it's really not worth your time to test this. Multiprocessor scalability was hardly even on the radar in 7.3 days. regards, tom lane