Re: Using pgiosim realistically - Mailing list pgsql-performance

From John Rouillard
Subject Re: Using pgiosim realistically
Date
Msg-id 20110517173519.GH27218@renesys.com
Whole thread Raw
In response to Re: Using pgiosim realistically  (Jeff <threshar@torgo.978.org>)
List pgsql-performance
On Mon, May 16, 2011 at 01:54:06PM -0400, Jeff wrote:
> Yep - you need multiple threads to get max throughput of your io.

I am running:

   ~/pgiosim -c -b 100G -v -t4 file[0-9]*

Will each thread move 100GB of data? I am seeing:

  158.69%,   4260 read,      0 written, 3407.64kB/sec  425.95 iops

Maybe the completion target percentage is off because of the threads?

--
                -- rouilj

John Rouillard       System Administrator
Renesys Corporation  603-244-9084 (cell)  603-643-9300 x 111

pgsql-performance by date:

Previous
From: Cédric Villemain
Date:
Subject: Re: Fill Factor
Next
From: Jim Nasby
Date:
Subject: Re: reducing random_page_cost from 4 to 2 to force index scan