Speed... - Mailing list pgsql-general

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
--
svenne@krap.dk
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