Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 1886F9F9905 for ; Tue, 21 Aug 2007 19:03:32 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 20660-02 for ; Tue, 21 Aug 2007 19:03:22 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from rv-out-0910.google.com (rv-out-0910.google.com [209.85.198.187]) by postgresql.org (Postfix) with ESMTP id 4ED799F959B for ; Tue, 21 Aug 2007 19:03:27 -0300 (ADT) Received: by rv-out-0910.google.com with SMTP id l15so1265141rvb for ; Tue, 21 Aug 2007 15:03:25 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; 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; b=DhmGekg765T+FOHVuKewwppiWox93sYOT//x/6hBdOA/fXuUzhj62PsZ3riwWtK0ROgGA3M21n420Qrdqcv81PUktHfFbl5zyCPnQUjmWTieh4Giu6wUxoIpyUyaep8ijaEyronPvB9JveLTopSQeP3ym8XP55IqulohBVeaPtU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=sQ8FhtNL7c1cSlq/0kptooyU/V81JmwGI7j7iGQCVSVXTuGbd64QVD1XETsMU9NaXAoqZR2FCTd087ZEIdFHytub1MwlT89/mV8gmoYiMGshQNpvWrbEqY2PNkQbG/VMdr4IN0FKbuaQF0w2iVxMsN5JCoXXejhDDeT+vKg7xak= Received: by 10.141.76.21 with SMTP id d21mr3672951rvl.1187733805811; Tue, 21 Aug 2007 15:03:25 -0700 (PDT) Received: by 10.141.98.12 with HTTP; Tue, 21 Aug 2007 15:03:25 -0700 (PDT) Message-ID: Date: Tue, 21 Aug 2007 17:03:25 -0500 From: "Scott Marlowe" To: "Sachchida Ojha" Subject: Re: Autovacuum is running forever Cc: "Michael Glaesemann" , pgsql-performance@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/222 X-Sequence-Number: 26352 On 8/21/07, Sachchida Ojha wrote: > Is there any data corruption/damage to the database if we forcefully > kill autovacuum using cron job (if it is running longer than a > predefined time frame). Not really. but vacuum will just have to run that long again plus some the next time it starts up. Again, it's better to run vacuum more often not less often, and keep the cost_delay high enough that it doesn't interfere with your I/O. however, that will make it run even longer.