On Fri, Jun 29, 2012 at 12:11 PM, Andres Freund <and...@2ndquadrant.com> wrote: > On Friday, June 29, 2012 07:07:11 PM Nils Goroll wrote: >> > Also, 20 transactions per connection is not enough of a run to make >> > any evaluation on. >> >> As you can see I've repeated the tests 10 times. I've tested slight >> variations as mentioned above, so I was looking for quick results with >> acceptable variation. > Running only 20 transactions is still meaningless. Quite often that will means > that no backends run concurrently because the starting up takes longer than to > process those 20 transactions. You need at the very, very least 10s. Check out > -T.
yeah. also, standard pgbench is typically very much i/o bound on typical hardware. it's would be much more interesting to see performance in spinlock heavy workloads -- the OP noted one when introducing the thread. would it be possible to simulate those conditions. merlin -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers