pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedQuestion of performance of version 8
3+ messages / 2 participants
[nested] [flat]
* Question of performance of version 8
@ 2004-12-21 01:42 kondo_yo@itg.hitachi.co.jp
0 siblings, 1 reply; 3+ messages in thread
From: kondo_yo@itg.hitachi.co.jp @ 2004-12-21 01:42 UTC (permalink / raw)
To: 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
$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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Question of performance of version 8
@ 2004-12-21 03:54 Tom Lane <tgl@sss.pgh.pa.us>
parent: kondo_yo@itg.hitachi.co.jp
0 siblings, 0 replies; 3+ messages in thread
From: Tom Lane @ 2004-12-21 03:54 UTC (permalink / raw)
To: kondo_yo@itg.hitachi.co.jp; +Cc: pgsql-performance
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Question of performance of version 8
@ 2004-12-21 05:04 kondo_yo@itg.hitachi.co.jp
0 siblings, 0 replies; 3+ messages in thread
From: kondo_yo@itg.hitachi.co.jp @ 2004-12-21 05:04 UTC (permalink / raw)
To: pgsql-performance
Thank you for your attention.
I will try again with new postgres release and
examine access method of sql with explain command.
kondo
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2004-12-21 05:04 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-12-21 01:42 Question of performance of version 8 kondo_yo@itg.hitachi.co.jp
2004-12-21 03:54 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-12-21 05:04 Re: Question of performance of version 8 kondo_yo@itg.hitachi.co.jp
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