Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Strange behavior: pgbench and new Linux kernels
- From: Greg Smith <gsmith(at)gregsmith(dot)com>
- To: Matthew <matthew(at)flymine(dot)org>
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: Strange behavior: pgbench and new Linux kernels
- Date: Sun, 18 May 2008 12:25:39 -0400 (EDT)
- Message-id: <Pine(dot)GSO(dot)4(dot)64(dot)0805180240590(dot)19416(at)westnet(dot)com>
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
- Prev by Date: Re: I/O on select count(*)
- Next by Date: Re: I/O on select count(*)
- Previous by thread: very slow left join
- Next by thread: slow update
- Indexes: