Re: [PERFORM] Question on pgbench output

2009-04-04 Thread David Kerr
On Fri, Apr 03, 2009 at 10:35:58PM -0400, Greg Smith wrote: - On Fri, 3 Apr 2009, Tom Lane wrote: - - and a bunch of postmaster ones, with "-c" (or by hitting "c" while top is - running) you can even see what they're all doing. If the pgbench process - is consuming close to 100% of a CPU's time

Re: [PERFORM] Strange behavior: pgbench and new Linux kernels

2009-04-04 Thread Greg Smith
On Sat, 4 Apr 2009, Josh Berkus wrote: Have you sent this to any Linux kernel engineers? My experience is that they're fairly responsive to this sort of thing. I'm going to submit an updated report to LKML once I get back from East, I want to test against the latest kernel first. -- * Greg

Re: [PERFORM] Strange behavior: pgbench and new Linux kernels

2009-04-04 Thread Josh Berkus
On 4/4/09 9:07 AM, Greg Smith wrote: On Tue, 31 Mar 2009, Kevin Grittner wrote: On Thu, Apr 17, 2008 at 7:26 PM, Greg Smith wrote: On this benchmark 2.6.25 is the worst kernel yet: I don't remember seeing a follow-up on this issue from last year. Are there still any particular kernels to a

Re: [PERFORM] Strange behavior: pgbench and new Linux kernels

2009-04-04 Thread Greg Smith
On Tue, 31 Mar 2009, Kevin Grittner wrote: On Thu, Apr 17, 2008 at 7:26 PM, Greg Smith wrote: On this benchmark 2.6.25 is the worst kernel yet: I don't remember seeing a follow-up on this issue from last year. Are there still any particular kernels to avoid based on this? I just discover

Re: [PERFORM] Using IOZone to simulate DB access patterns

2009-04-04 Thread henk de wit
> $ apt-cache search iozone > iozone3 - Filesystem and Disk Benchmarking Tool You are right. I was confused with IOMeter, which can't be run on Linux (the Dynamo part can, but that's not really useful without the 'command & control' part). __

Re: [PERFORM] Using IOZone to simulate DB access patterns

2009-04-04 Thread Jesper Krogh
henk de wit wrote: I've been using Bonnie++ for ages to do filesystem testing of new DB servers. But Josh Drake recently turned me on to IOZone. Perhaps a little off-topic here, but I'm assuming you are using Linux to test your DB server (since you mention Bonnie++). But it seems to me that

Re: [PERFORM] Using IOZone to simulate DB access patterns

2009-04-04 Thread henk de wit
> I've been using Bonnie++ for ages to do filesystem testing of new DB servers. > But Josh Drake recently turned me on to IOZone. Perhaps a little off-topic here, but I'm assuming you are using Linux to test your DB server (since you mention Bonnie++). But it seems to me that IOZone only has a