Re: Question about hosting and server grade

From: Sam Mason <sam(at)samason(dot)me(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Question about hosting and server grade
Date: 2009-03-26 15:15:24
Message-ID: 20090326151524.GF12225@frubble.xen.chris-lamb.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Mar 26, 2009 at 09:06:03AM +0100, Ivan Sergio Borgonovo wrote:
> Could IO load show up as apparent CPU load?

I may not be interpreting you correctly; but, as I understand it, if
your IO subsystem is too slow then your CPUs are going to be idling. So
if your CPUs are sitting at 100% utilisation then you're CPU bound and
not IO bound.

If your dataset mainly fits in RAM then SELECTs are always going to be
CPU (or RAM to cache bandwidth) bound. You'll always be waiting for
your disks when you modify data so if you consider your UPDATEs too
slow you should look at what's going on in your system when they're
happening.

--
Sam http://samason.me.uk/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sam Mason 2009-03-26 15:19:36 Re: log shipping from 64 bit linux server to a 32 bit linux server
Previous Message Albe Laurenz 2009-03-26 15:07:32 Re: Weird encoding behavior