Re: Strange behavior: pgbench and new Linux kernels

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(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD