Question of performance of version 8
| От | kondo_yo@itg.hitachi.co.jp | 
|---|---|
| Тема | Question of performance of version 8 | 
| Дата | |
| Msg-id | XNM1$2$0$3$$7$7$8$A$0001492U41c77f63@itg.hitachi.co.jp обсуждение исходный текст | 
| Ответы | Re: Question of performance of version 8 | 
| Список | pgsql-performance | 
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
 CPU   Pentium Ⅲ  531.986 MHz
 Memory  125660 Kb
-------------------------------------------------------
Software version
 OS Linux Kernel:2.4.21-4.EL
 Distribution: Red Hat Enterprise Linux AS release 3
-------------------------------------------------------
Result(transaction per second)
             first  second third
  7.4.6      6.8    6.8    5.9
  8.0 beta4   4.3    4.6   4.4
-------------------------------------------------------
Parameter of DBT1,PostgreSQL
 Database Size (items): 1000
 Database Size (customers): 10
 number of cache: 1
 number of connections between cache and database: 10
 number of application server: 1
 number of connections between server and database: 20
 number of drivers: 1
 eus/driver: 100
 rampuprate/driver: 60
 duration/driver: 900
 thinktime/driver: 1.6
 Put WAL on different driver: 0
 Put pgsql_tmp on different driver: 0
 database parameters: -i -c listen_addresses='*'
 shmmax: 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
		
	В списке pgsql-performance по дате отправления: