X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 9CE769F96B6 for ; Wed, 10 May 2006 04:08:42 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 49938-08 for ; Wed, 10 May 2006 04:08:33 -0300 (ADT) X-Greylist: delayed 02:50:00.904061 by SQLgrey- Received: from mail2.mailhostingservice.com (mail2.mailhostingservice.com [216.154.198.172]) by postgresql.org (Postfix) with SMTP id 8DE679F931D for ; Wed, 10 May 2006 04:08:33 -0300 (ADT) Received: From [192.168.2.24] (203.144.16.126) by mail1.mailhostingservice.com Id <56d3d4d31ab0626880d3f83c8627be8c027c4c82@mail1.mailhostingservice.com> ; Wed, 10 May 2006 04:19:27 +0000 Message-ID: <44616987.3030900@wildcash.com> Date: Wed, 10 May 2006 14:18:15 +1000 From: Rudi Starcevic User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.12) Gecko/20050915 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: VACUUM killing my CPU References: <1147167937.749400.182820@u72g2000cwu.googlegroups.com> <200605092108.33329@hal.medialogik.com> In-Reply-To: <200605092108.33329@hal.medialogik.com> X-Enigmail-Version: 0.93.0.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/230 X-Sequence-Number: 19017 Hi, >>What I am worry about is "93.5% wa" ... >> >>Could someone explain me what is the VACUUM process waiting for ? >> > > > Disk I/O. > CPU wa: Time spent waiting for IO. Prior to Linux 2.5.41, shown as zero. Just a little more info to help understand what Alan has pointed out. Your CPU processes are waiting on the HDD ... HTH -- Regards, Rudi