Re: Using IOZone to simulate DB access patterns

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>
Cc: henk de wit <henk53602(at)hotmail(dot)com>, jesper(at)krogh(dot)cc, pgsql-performance(at)postgresql(dot)org
Subject: Re: Using IOZone to simulate DB access patterns
Date: 2009-04-10 17:10:03
Message-ID: 49DF7D6B.9020107@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Carey 2009-04-10 17:11:46 Re: Using IOZone to simulate DB access patterns
Previous Message Josh Berkus 2009-04-10 17:07:49 Re: Shouldn't the planner have a higher cost for reverse index scans?