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 7734ED1B550 for ; Tue, 12 Aug 2003 02:37:28 +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 77812-07 for ; Mon, 11 Aug 2003 23:36:01 -0300 (ADT) Received: from hub.org (hub.org [64.117.225.220]) by svr1.postgresql.org (Postfix) with ESMTP id A1A8FD1B539 for ; Mon, 11 Aug 2003 23:37:17 -0300 (ADT) Received: from hub.org (unknown [64.117.225.220]) by hub.org (Postfix) with ESMTP id 871B39A7B7F for ; Mon, 11 Aug 2003 23:37:21 -0300 (ADT) X-Received: from localhost ([unix socket]) by hub.org (Cyrus v2.2.prealpha) with LMTP; Mon, 11 Aug 2003 23:35:28 -0300 X-Sieve: CMU Sieve 2.2 X-Received: from postgresql.org (developer.postgresql.org [64.117.224.193]) by hub.org (Postfix) with ESMTP id BFBA39A7B86 for ; Mon, 11 Aug 2003 23:35:26 -0300 (ADT) X-Original-To: pgsql-performance-postgresql.org-owner@localhost.postgresql.org X-Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 98DFBD1B524 for ; Tue, 12 Aug 2003 02:35:16 +0000 (GMT) X-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 80373-02 for ; Mon, 11 Aug 2003 23:33:48 -0300 (ADT) X-Received: from web15106.mail.bjs.yahoo.com (web15106.mail.bjs.yahoo.com [202.3.77.151]) by svr1.postgresql.org (Postfix) with SMTP id 749AAD1B550 for ; Mon, 11 Aug 2003 23:35:02 -0300 (ADT) Message-ID: <20030812023504.27034.qmail@web15106.mail.bjs.yahoo.com> X-Received: from [137.189.4.4] by web15106.mail.bjs.yahoo.com via HTTP; Tue, 12 Aug 2003 10:35:04 CST Date: Tue, 12 Aug 2003 10:35:04 +0800 (CST) From: =?gb2312?q?xin=20fu?= Subject: about performance of postgreSQL To: pgsql-performance-owner@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1101371436-1060655704=:24053" Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at postgresql.org ReSent-Date: Mon, 11 Aug 2003 23:37:17 -0300 (ADT) Resent-From: "Marc G. Fournier" Resent-To: pgsql-performance@postgresql.org ReSent-Subject: about performance of postgreSQL ReSent-Message-ID: <20030811233717.K6860@hub.org> X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=1.8 tagged_above=0.0 required=5.0 tests=FROM_ENDS_IN_NUMS, HTML_10_20 X-Spam-Level: * X-Archive-Number: 200308/191 X-Sequence-Number: 3008 --0-1101371436-1060655704=:24053 Content-Type: text/plain; charset=gb2312 Content-Transfer-Encoding: 8bit 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!? 暑期大片齐聚雅虎通 网络摄像头+雅虎通调频收音机等你来拿 --0-1101371436-1060655704=:24053 Content-Type: text/html; charset=gb2312 Content-Transfer-Encoding: 8bit
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!?
暑期大片齐聚雅虎通 网络摄像头+雅虎通调频收音机等你来拿 --0-1101371436-1060655704=:24053--