X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5841A3ABAA0 for ; Tue, 21 Dec 2004 03:54:25 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 30174-07 for ; Tue, 21 Dec 2004 03:54:18 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 48FC03ABABE for ; Tue, 21 Dec 2004 03:54:21 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id iBL3sKgo002256; Mon, 20 Dec 2004 22:54:20 -0500 (EST) To: kondo_yo@itg.hitachi.co.jp Cc: pgsql-performance@postgresql.org Subject: Re: Question of performance of version 8 In-reply-to: References: Comments: In-reply-to kondo_yo@itg.hitachi.co.jp message dated "Tue, 21 Dec 2004 10:42:10 +0900" Date: Mon, 20 Dec 2004 22:54:20 -0500 Message-ID: <2255.1103601260@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.004 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200412/255 X-Sequence-Number: 9630 kondo_yo@itg.hitachi.co.jp writes: > I tried performance test of version 8.0.0 beta4 by osdl-dbt-1. > The result is that throughput of version 8 fell to about 70 percent > compared with V7.4.6. beta4 is a little bit back ... I don't have dbt1 at hand, but I tried pg_bench on PG 7.4.6 against 8.0rc2 just now. For the test case pgbench -i -s 10 bench pgbench -c 10 -t 10000 bench on 7.4.6 I get: starting vacuum...end. transaction type: TPC-B (sort of) scaling factor: 10 number of clients: 10 number of transactions per client: 10000 number of transactions actually processed: 100000/100000 tps = 65.714249 (including connections establishing) tps = 65.716363 (excluding connections establishing) on 8.0rc2 I get: starting vacuum...end. transaction type: TPC-B (sort of) scaling factor: 10 number of clients: 10 number of transactions per client: 10000 number of transactions actually processed: 100000/100000 tps = 107.379742 (including connections establishing) tps = 107.385301 (excluding connections establishing) This is on a Fedora Core 3 machine, generic three-year-old PC with cheap junk IDE drive that lies about write completion (but I'm running fsync off so that hardly matters ;-)). And I didn't change any of the default postgresql.conf settings, just started the postmaster with -F in both cases. So I wouldn't claim that it's very representative of real-world performance on real-world server hardware. But I'm not seeing a serious falloff from 7.4 to 8.0 here --- more the other way 'round. Please try dbt1 with 8.0rc2, and let us know if you still see a problem. regards, tom lane