Re: Speed / Server

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Nikolas Everett <nik9000(at)gmail(dot)com>
Cc: anthony(at)resolution(dot)com, pgsql-performance(at)postgresql(dot)org
Subject: Re: Speed / Server
Date: 2009-10-06 14:26:13
Message-ID: dcc563d10910060726i79cdb7c7ldf143bd0337270f9@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, Oct 6, 2009 at 7:21 AM, Nikolas Everett <nik9000(at)gmail(dot)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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Michal Vitecek 2009-10-06 14:59:20 Re: updating a row in a table with only one row
Previous Message Karl Denninger 2009-10-06 13:39:11 Re: Best suiting OS