On Wed, 29 Jul 2009, Stefan Kaltenbrunner wrote:
oh - the 90k tps are with the new multithreaded pgbench? missed that fact. As you can see from my results I managed to get 83k with the 8.4 pgbench on a slightly slower Nehalem which does not sound too impressive for the new code...
I got 96K with the default postgresql.conf - 32MB shared_buffers etc. - and I didn't even try to find the sweet spot yet for things like number of threads, that's just the first useful number that popped out. I saw as much as 87K with the regular one too. I already planned to run the test set you did for comparison sake at some point.
-- * Greg Smith gsmith@xxxxxxxxxxxxx http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
