[PERFORM] pgbench Comparison of 7.4.7 to 8.0.2

[Thomas F . O'Connell]

I'm in the fortunate position of having a newly built database server 
that's pre-production. I'm about to run it through the ringer with some 
simulations of business data and logic, but I wanted to post the 
results of some preliminary pgbench marking.

http://www.sitening.com/pgbench.html
To me, it looks like basic transactional performance is modestly 
improved at 8.0 across a variety of metrics. I think this bodes well 
for more realistic loads, but I'll be curious to see the results of 
some of the simulations.

I've still got a little bit of preparatory time with this box, so I can 
continue to do some experimentation.

I'd be curious to see whether these numbers meet developer expectations 
and to see whether the developer and user community have insight into 
other pgbench options that would be useful to see.

Thanks!
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source: Open Your i™
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])