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/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general