Public feed #376658

Miscellany

public text v1 · immutable
Raw Edit
·published 2007-03-01 05:12 UTC
rendered paste body
VACUUM
CHECKPOINT
===== sync ======
10 concurrent users...
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 10
number of transactions per client: 100
number of transactions actually processed: 1000/1000
tps = 59.348312 (including connections establishing)
tps = 59.875833 (excluding connections establishing) -- freebsd 6.2

VACUUM
CHECKPOINT
===== sync ======
10 concurrent users...
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 10
number of transactions per client: 100
number of transactions actually processed: 1000/1000
tps = 133.669593 (including connections establishing)
tps = 136.023053 (excluding connections establishing) -- netbsd 4.0


same postgresql.conf used on both servers, with identical hardware. SMP P3 877mhz / 1gig ram / IDE 36gig deskstar hard drives (7200rpm). How is NetBSD with its Biglock implementation doing so much better?