Re: Using IOZone to simulate DB access patterns - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Using IOZone to simulate DB access patterns
Date
Msg-id 49DF7D6B.9020107@agliodbs.com
Whole thread Raw
In response to Re: Using IOZone to simulate DB access patterns  (Mark Kirkwood <markir@paradise.net.nz>)
List pgsql-performance
On 4/9/09 11:26 PM, Mark Kirkwood wrote:
> Josh Berkus wrote:
>> All,
>>
>> Wow, am I really the only person here who's used IOZone?
>>
>
> No - I used to use it exclusively, but everyone else tended to demand I
> redo stuff with bonnie before taking any finding seriously... so I've
> kinda 'submitted to the Borg' as it were....

Bonnie++ has its own issues with concurrency; it's using some kind of
ad-hoc threading implementation, which results in not getting real
parallelism.   I just did a test with -c 8 on Bonnie++ 1.95, and the
program only ever used 3 cores.


--
Josh Berkus
PostgreSQL Experts Inc.
www.pgexperts.com

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Shouldn't the planner have a higher cost for reverse index scans?
Next
From: Scott Carey
Date:
Subject: Re: Using IOZone to simulate DB access patterns