Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 6C1622E005F for ; Fri, 18 Apr 2008 14:32:13 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 17563-01 for ; Fri, 18 Apr 2008 14:32:09 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wf-out-1314.google.com (wf-out-1314.google.com [209.85.200.173]) by developer.postgresql.org (Postfix) with ESMTP id 0CA4A2E003D for ; Fri, 18 Apr 2008 14:32:08 -0300 (ADT) Received: by wf-out-1314.google.com with SMTP id 28so498991wff.28 for ; Fri, 18 Apr 2008 10:32:08 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=AnmdWMZmdAeZpP1fHu9TRMdi2ubENWkjlKxVM1hhPh0=; b=alu0XA/J4f8YfoF6GLlIojy3f0ISOx2BeiP0nFzP7WoMJ3eLwmdHJIh8u01sqFrT0PAmL1avI0mShbNlVzTs30RAR7AutpArlv+5myrAkQPvXCQtKklVL8BBsKrduimks/wOwNaBMKPIziyTToJRAq6ZqQNIO67CVGzDLKDqL94= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=k8iLpBIWqqyu8UX5ts1g9e4ec6ttK4Wr9IwfXCFO0EFbJ9DrE+ZMOElmwIjb8dXcVaBbk4gaB8EiQ4tDRRAn/oYrk5aRiWMAeY9WJOkuxPLBVhKYIlQtelaD/dmdekexJtY2LFN4V3KsxHNnOVdGsV4lNPdv0rFBpVVoIDKlITk= Received: by 10.142.44.11 with SMTP id r11mr730580wfr.22.1208539928232; Fri, 18 Apr 2008 10:32:08 -0700 (PDT) Received: by 10.142.185.20 with HTTP; Fri, 18 Apr 2008 10:32:05 -0700 (PDT) Message-ID: Date: Fri, 18 Apr 2008 10:32:05 -0700 From: "Jeffrey Baker" To: "Tom Lane" Subject: Re: 3-days-long vacuum of 20GB table Cc: pgsql-performance@postgresql.org In-Reply-To: <3630.1208538238@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <3630.1208538238@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/272 X-Sequence-Number: 29765 On Fri, Apr 18, 2008 at 10:03 AM, Tom Lane wrote: > "Jeffrey Baker" writes: > > This autovacuum has been hammering my server with purely random i/o > > for half a week. The table is only 20GB and the i/o subsystem is good > > for 250MB/s sequential and a solid 5kiops. When should I expect it to > > end (if ever)? > > What have you got maintenance_work_mem set to? Which PG version > exactly? This is 8.1.9 on Linux x86_64, # show maintenance_work_mem ; maintenance_work_mem ---------------------- 16384