Hi,
Below are some results of running pgbench, run on a machine that is doing
nothing else than running PostgreSQL woth pgbench. The strange thing is that
the results are *constantly alternating* hight (750-850 transactions)and low
(50-80 transactions), no matter how many test I run. If I wait a long time (> 5
minutes) after running the test, I always get a hight score, followed by a low
one, followed by a high one, low one etc.
I was expecting a low(ish) score the first run (because the tables are not
loaded in the cache yet), followed by continues high(ish) scores, but not an
alternating pattern. I also did not expect so much difference, given the
hardware I have (Dual Opteron, 4GB memory , 3Ware SATA RAID5 with 5 disks,
seerate swap and pg_log disks).
Anyone any idea?
Results of pgbench:
[EMAIL PROTECTED]:/usr/lib/postgresql/8.1/bin$ ./pgbench -c 10 -t 150 test
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 100
number of clients: 10
number of transactions per client: 150
number of transactions actually processed: 1500/1500
tps = 50.651705 (including connections establishing)
tps = 50.736338 (excluding connections establishing)
[EMAIL PROTECTED]:/usr/lib/postgresql/8.1/bin$ ./pgbench -c 10 -t 150 test
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 100
number of clients: 10
number of transactions per client: 150
number of transactions actually processed: 1500/1500
tps = 816.972995 (including connections establishing)
tps = 836.951755 (excluding connections establishing)
[EMAIL PROTECTED]:/usr/lib/postgresql/8.1/bin$ ./pgbench -c 10 -t 150 test
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 100
number of clients: 10
number of transactions per client: 150
number of transactions actually processed: 1500/1500
tps = 42.924294 (including connections establishing)
tps = 42.986747 (excluding connections establishing)
[EMAIL PROTECTED]:/usr/lib/postgresql/8.1/bin$ ./pgbench -c 10 -t 150 test
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 100
number of clients: 10
number of transactions per client: 150
number of transactions actually processed: 1500/1500
tps = 730.651970 (including connections establishing)
tps = 748.538852 (excluding connections establishing)
TIA
Groeten,
Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: [EMAIL PROTECTED]
web: www.askesis.nl
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
