Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id E54309FA01A for ; Tue, 21 Aug 2007 18:47:28 -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 15871-05-3 for ; Tue, 21 Aug 2007 18:47:20 -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.189]) by postgresql.org (Postfix) with ESMTP id 6C5F49FA000 for ; Tue, 21 Aug 2007 18:47:25 -0300 (ADT) Received: by rv-out-0910.google.com with SMTP id l15so1261818rvb for ; Tue, 21 Aug 2007 14:47:19 -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=Ei2mSx7JNTsRuY4I+JIADXx/6U+8Rso/VjSqRw4qKKytvKSCd64xlwc8+zQ8gtj/G0TKiqQ0R4JNKi5ubANdl2OEPWzjB0LTRX4qhd8feSgLqKLWPwqWBLLASXmtgEvv7DT3c16PYgeoYO4zCr0VNu+kx0sfbveVUmdLqEuXnsg= 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=r/5w2kcKMNLD3xVxH0GDgWhcOYzfZMWYvmB7BkwVu/kzopADeLUzzwDJx0vKg7ZjIRGy0bqYTJPDVumf0jg8VZtJZA/hDx4uVwlfgZKPuuT1SAkfaB2i+17ms2PJEA3d8XPH7UdJ/EutADq0dvrde3gcRpvAHrgack1Bp7bMBaU= Received: by 10.141.209.7 with SMTP id l7mr1258177rvq.1187732838821; Tue, 21 Aug 2007 14:47:18 -0700 (PDT) Received: by 10.141.98.12 with HTTP; Tue, 21 Aug 2007 14:47:18 -0700 (PDT) Message-ID: Date: Tue, 21 Aug 2007 16:47:18 -0500 From: "Scott Marlowe" To: "Sachchida Ojha" Subject: Re: Autovacuum running forever Cc: 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: <46CB0979.7050104@Sun.COM> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/217 X-Sequence-Number: 26347 On 8/21/07, Sachchida Ojha wrote: > > > Is there any way to stop the autovacuum if it is running longer than 10 min > or so? > > Is it good idea to kill autovacuum if it is running longer than expected? > > In my OLTP system, we are inserting, updating and deleting the data every > second. > > Autovacuum started and never finished slowing down the whole system. It's probably better to adjust the sleep parameters in postgresql.conf and then pg_ctl reload You can kill the autovacuum backend, but it will just start up again when the sleep time has passed.