Hi again,
I have been following this list for approx. 6600 messages (i think
that is 2 months or so.. .) - an yes.. Like the Cardassian Order I
keep everything :)
A couple of time, ppl has been talking about speed..
What about a couple of benchmarks from your systems, so that us
newbies (or almost) can se, how much we can expect to be able to
tune up to..
I can "go first" :)
An comments for further tuning is apreciated... btw.. the box gets
its memory doubled sometimes next week.
My setup:
Duron 750 MHz.
256 Megs memory
IBM Deskstar IDE-harddrive (no raid, no nothing)
Running 7.1.2
### BTW: this is not the box mentioned in another question this
evening.. this I my private "toybox"..
some content of postgresql.conf :
max_connections = 512
hostname_lookup = false
sort_mem = 4096
shared_buffers = 1024 # min 16
sync = false
#wal_buffers = 8
#wal_files = 0
#wal_sync_method = fsync
#wal_debug = 0
#commit_delay = 0
#commit_siblings = 5
#checkpoint_segments = 3
#checkpoint_timeout = 300
(a side question ... does this mean, that I even haven't enabled the
"magic" WAL ?)
using pgbench from /contrib i get :
sk@kitten:/usr/src/postgresql-7.1.2/contrib/pgbench > ./pgbench
pgbench -c 40
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 1
number of clients: 40
number of transactions per client: 10
number of transactions actually processed: 400/400
tps = 106.943436(including connections establishing)
tps = 125.524811(excluding connections establishing)
sk@kitten:/usr/src/postgresql-7.1.2/contrib/pgbench > ./pgbench
pgbench -c 100
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 1
number of clients: 100
number of transactions per client: 10
number of transactions actually processed: 1000/1000
tps = 88.924498(including connections establishing)
tps = 101.360871(excluding connections establishing)
sk@kitten:/usr/src/postgresql-7.1.2/contrib/pgbench > ./pgbench
pgbench -c 200
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 1
number of clients: 200
number of transactions per client: 10
number of transactions actually processed: 2000/2000
tps = 67.320263(including connections establishing)
tps = 74.500643(excluding connections establishing)
sk@kitten:/usr/src/postgresql-7.1.2/contrib/pgbench > ./pgbench
pgbench -c 300
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 1
number of clients: 300
number of transactions per client: 10
number of transactions actually processed: 3000/3000
tps = 48.291555(including connections establishing)
tps = 51.892547(excluding connections establishing)
Tia
Svenne
--
[EMAIL PROTECTED]
http://www.krap.dk
ICQ 5434480
PGP-key http://keys.pgp.dk:11371/pks/lookup?op=get&search=0xDF484022
PGP @ http://www.pgp.com / http://www.phpi.com
---------------------------(end of broadcast)---------------------------
TIP 3: 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
