pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: kondo_yo@itg.hitachi.co.jp
To: pgsql-performance@postgresql.org
Subject: Question of performance of version 8
Date: Tue, 21 Dec 2004 10:42:10 +0900
Message-ID: <XNM1$2$0$3$$7$7$8$A$0001492U41c77f63@itg.hitachi.co.jp> (raw)


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



view thread (3+ messages)  latest in thread

Message-ID: <XNM1$2$0$3$$7$7$8$A$0001492U41c77f63@itg.hitachi.co.jp>
Permalink:  ../XNM1$2$0$3$$7$7$8$A$0001492U41c77f63@itg.hitachi.co.jp/
Also on:    postgresql.org/message-id/XNM1$2$0$3$$7$7$8$A$0001492U41c77f63@itg.hitachi.co.jp

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: kondo_yo@itg.hitachi.co.jp
  Subject: Re: Question of performance of version 8
  In-Reply-To: <XNM1$2$0$3$$7$7$8$A$0001492U41c77f63@itg.hitachi.co.jp>
  References: <XNM1$2$0$3$$7$7$8$A$0001492U41c77f63@itg.hitachi.co.jp>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox