Re: Speed / Server - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: Speed / Server
Date
Msg-id dcc563d10910061228h6616a3dmad1fdd92daccb1a5@mail.gmail.com
Whole thread Raw
In response to Re: Speed / Server  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: Speed / Server
List pgsql-performance
On Tue, Oct 6, 2009 at 8:26 AM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> 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.

note that spare IO also means we can subscribe a slony slave midday or
run a query on a large data set midday and not overload our servers.
Spare CPU capacity is nice, spare IO is a necessity.

pgsql-performance by date:

Previous
From: david@lang.hm
Date:
Subject: Re: Best suiting OS
Next
From: Karl Denninger
Date:
Subject: Re: Speed / Server