On Fri, 18 Apr 2008, Matthew wrote:
So what happens if you run pgbench on a separate machine to the server? Does the problem still exist in that case?
It does not. At the low client counts, there's a big drop-off relative to running on localhost just because of running over the network. But once I get to 4 clients the remote pgbench setup is even with the localhost one. At 50 clients, the all local setup is at 8100 tps while the remote pgbench is at 26000.
So it's pretty clear to me now that the biggest problem here is the pgbench client itself not working well at all with the newer kernels. It's difficult to see through that to tell for sure how well each kernel version is handling the server portion of the job underneath. I hope to have time this week to finally submit all this to lkml.
-- * Greg Smith gsmith@xxxxxxxxxxxxx http://www.gregsmith.com Baltimore, MD
