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