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 9F0659FA4F1 for ; Wed, 10 May 2006 01:08:54 -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 27732-07 for ; Wed, 10 May 2006 01:08:45 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from skynet.simkin.ca (skynet.simkin.ca [199.175.137.210]) by postgresql.org (Postfix) with ESMTP id C23899FA4E1 for ; Wed, 10 May 2006 01:08:45 -0300 (ADT) Received: from charon.medialogik.com (S0106000c6eb33e73.vf.shawcable.net [70.68.174.20]) (using TLSv1 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by skynet.simkin.ca (Postfix) with ESMTP id 5FA9E106DC for ; Tue, 9 May 2006 21:08:43 -0700 (PDT) From: Alan Hodgson Organization: Simkin Network Consulting To: pgsql-performance@postgresql.org Subject: Re: VACUUM killing my CPU Date: Tue, 9 May 2006 21:08:33 -0700 User-Agent: KMail/1.8.3 References: <1147167937.749400.182820@u72g2000cwu.googlegroups.com> In-Reply-To: <1147167937.749400.182820@u72g2000cwu.googlegroups.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200605092108.33329@hal.medialogik.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/222 X-Sequence-Number: 19009 On May 9, 2006 02:45 am, blender@jaskom.pl wrote: > What I am worry about is "93.5% wa" ... > > Could someone explain me what is the VACUUM process waiting for ? > Disk I/O. -- In a truly free society, "Alcohol, Tobacco and Firearms" would be a convenience store chain.