X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 81BE6D1C4CC for ; Tue, 12 Aug 2003 17:26:07 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 84633-08 for ; Tue, 12 Aug 2003 14:24:34 -0300 (ADT) Received: from mail.travelamericas.com (dsl231-059-037.sea1.dsl.speakeasy.net [216.231.59.37]) by svr1.postgresql.org (Postfix) with SMTP id 050AAD1C4BA for ; Tue, 12 Aug 2003 14:25:56 -0300 (ADT) Received: (qmail 20346 invoked from network); 12 Aug 2003 17:26:17 -0000 Received: from unknown (HELO travelamericas.com) (127.0.0.1) by localhost with SMTP; 12 Aug 2003 17:26:17 -0000 Message-ID: <3F392339.5000007@travelamericas.com> Date: Tue, 12 Aug 2003 10:26:17 -0700 From: Chris Travers User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.3) Gecko/20030312 X-Accept-Language: en-us, en MIME-Version: 1.0 To: xin fu Cc: pgsql-performance@postgresql.org Subject: Re: about performance of postgreSQL References: <20030812023504.27034.qmail@web15106.mail.bjs.yahoo.com> In-Reply-To: <20030812023504.27034.qmail@web15106.mail.bjs.yahoo.com> Content-Type: text/plain; charset=GB2312 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/209 X-Sequence-Number: 3026 Hi Xin; PostgreSQL is configured to run on virutally anything out of the box. The reason for this is that, like Oracle, the database manager will not start if it cannot allocate sufficient resources. We take the approach of ensuring that it will start so you can tune it. I would recomment trying to take a close look at many of the posts on the Performance list (searching the archives) and paying attention to things such as effective_cache_size and shared_buffers. If these don't answer your questions, ask this list again. Best Wishes, Chris Travers xin fu wrote: > Dear master: > I have learned postgreSQL for serveral days, now i meet some problems. > when I use a TPCC(Transaction Processing Performance Council) test > program to test the performance of postgreSQL , postgreSQL works very > slowly, it almost need 1 minute to finish a transaction, and the CPU > percent is almost 100%, > the test environment is : > OS: redhat 9.0(ext3, default configurations) > Server: postgre7.3.4(default configurations) , PIII 800M, 1G Memory > Client: tpcc test program,using ODBC API, PIII 800M, 1G Memory > when using SQLServer, it can work on a workload of 40 Warehouse, > but postgreSQL can not work even on 1 warehouse. I think there must be > some problem with my postgreSQL, can you help me? > I am in china, and my english is very poor, but i hope you can give > me some advice, thanks. > > > ------------------------------------------------------------------------ > *Do You Yahoo!?* > 暑期大片齐聚雅虎通 网络摄像头+雅虎通调频收音机等你来拿 >