Re: Speed / Server - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: Speed / Server
Date
Msg-id dcc563d10910060726i79cdb7c7ldf143bd0337270f9@mail.gmail.com
Whole thread Raw
In response to Re: Speed / Server  (Nikolas Everett <nik9000@gmail.com>)
Responses Re: Speed / Server
List pgsql-performance
On Tue, Oct 6, 2009 at 7:21 AM, Nikolas Everett <nik9000@gmail.com> wrote:
> If my un-word wrapping is correct your running ~90% user cpu.  Yikes.  Could
> you get away with fewer disks for this kind of thing?

Probably, but the same workload on a 6 disk RAID-10 is 20% or so
IOWAIT.  So somewhere between 6 and 12 disks we go from significant
IOWAIT to nearly none.  Given that CPU bound workloads deteriorate
more gracefully than IO Bound, I'm pretty happy having enough extra IO
bandwidth on this machine.

pgsql-performance by date:

Previous
From: Karl Denninger
Date:
Subject: Re: Best suiting OS
Next
From: Michal Vitecek
Date:
Subject: Re: updating a row in a table with only one row