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 4021B3AB56E for ; Tue, 21 Dec 2004 01:42:39 +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 67377-04 for ; Tue, 21 Dec 2004 01:42:26 +0000 (GMT) Received: from mail4.hitachi.co.jp (mail4.hitachi.co.jp [133.145.228.5]) by svr1.postgresql.org (Postfix) with ESMTP id 5CB143AB52A for ; Tue, 21 Dec 2004 01:42:28 +0000 (GMT) Received: from mc2.mcg.hitachi.co.jp (unknown [133.144.237.46]) by mail4.hitachi.co.jp (Postfix) with ESMTP id 3950633CCB for ; Tue, 21 Dec 2004 10:42:28 +0900 (JST) Received: (from root@localhost) by mc2.mcg.hitachi.co.jp (8.11.6+Sun/8.11.6) id iBL1gRS24680 for pgsql-performance@postgresql.org; Tue, 21 Dec 2004 10:42:27 +0900 (JST) Received: from unknown [192.168.2.1] by mc2.mcg.hitachi.co.jp with SMTP id LAA24675; Tue, 21 Dec 2004 10:42:27 +0900 Received: from navsg6.hitachi.co.jp by navsg6.hitachi.co.jp (8.9.3/3.7W-navsg6) id KAA12748; Tue, 21 Dec 2004 10:42:27 +0900 (JST) From: kondo_yo@itg.hitachi.co.jp Received: from mlsv4.itg.hitachi.co.jp ([158.213.165.103]) by navsg6.hitachi.co.jp (SAVSMTP 3.1.6.45) with SMTP id M2004122110422602353 for ; Tue, 21 Dec 2004 10:42:26 +0900 Received: from mfilter-s1.itg.hitachi.co.jp by mlsv4.itg.hitachi.co.jp (8.12.10/8.12.10) id iBL1gQAx008873; Tue, 21 Dec 2004 10:42:27 +0900 Received: from navgw6.itg.hitachi.co.jp (unverified) by mfilter-s1.itg.hitachi.co.jp (Content Technologies SMTPRS 4.3.17) with SMTP id for ; Tue, 21 Dec 2004 10:42:26 +0900 Received: from smgw01.itg.hitachi.co.jp. ([158.213.165.30]) by navgw6.itg.hitachi.co.jp (SMSSMTP 4.0.5.66) with SMTP id M2004122110422601550 for ; Tue, 21 Dec 2004 10:42:26 +0900 Received: from 127.0.0.1 by smgw01.itg.hitachi.co.jp. (8.9.3 (PHNE_28809+JAGae91741+JAGae92668)/8.7.1) id KAA23282; Tue, 21 Dec 2004 10:42:26 +0900 (JST) Message-Type: Multiple Part MIME-Version: 1.0 Message-ID: Content-Type: text/plain; charset=ISO-2022-JP To: Date: Tue, 21 Dec 2004 10:42:10 +0900 Importance: normal Subject: Question of performance of version 8 X400-Content-Identifier: X41C77F6300000M X400-MTS-Identifier: [/C=JP/ADMD=HITNET/PRMD=HITACHI/;gmml0204122110415555F] Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.178 tagged_above=0 required=5 tests=NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200412/254 X-Sequence-Number: 9629 Hello. 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. Test result is below. (measurement was repeated 3 times) ------------------------------------------------------- Hardware spec $B!!(BCPU$B!!!!!!(BPentium $B-7(B 531.986 MHz $B!!(BMemory$B!!!!(B125660 Kb ------------------------------------------------------- Software version $B!!(BOS$B!!(BLinux Kernel:2.4.21-4.EL $B!!(BDistribution: Red Hat Enterprise Linux AS release 3 ------------------------------------------------------- Result$B!J(Btransaction per second$B!K(B first second third 7.4.6 $B!!(B 6.8 6.8 5.9 8.0 beta4 4.3 4.6 $B!!(B4.4 ------------------------------------------------------- Parameter of DBT1,PostgreSQL $B!!(BDatabase Size (items): 1000 $B!!(BDatabase Size (customers): 10 $B!!(Bnumber of cache: 1 $B!!(Bnumber of connections between cache and database: 10 $B!!(Bnumber of application server: 1 $B!!(Bnumber of connections between server and database: 20 $B!!(Bnumber of drivers: 1 $B!!(Beus/driver: 100 $B!!(Brampuprate/driver: 60 $B!!(Bduration/driver: 900 $B!!(Bthinktime/driver: 1.6 $B!!(BPut WAL on different driver: 0 $B!!(BPut pgsql_tmp on different driver: 0 $B!!(Bdatabase parameters: -i -c listen_addresses='*' $B!!(Bshmmax: 33554432 ------------------------------------------------------- - Both version 8 and version 7 are performed under the same condition. - Tuning of adjustment of a parameter was not carried out at all. - The server and client process are performed in the same machine. Is there the weak point on the performance in version 8.0.0 ? Any help would greatly appreciated. kondou