Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id B4F829F9F9D for ; Tue, 21 Aug 2007 18:36:11 -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 11475-05 for ; Tue, 21 Aug 2007 18:36:03 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mtao02.charter.net (mtao02.charter.net [209.225.8.187]) by postgresql.org (Postfix) with ESMTP id 42E0B9F95AF for ; Tue, 21 Aug 2007 18:36:08 -0300 (ADT) Received: from aa02.charter.net ([10.20.200.154]) by mtao02.charter.net (InterMail vM.7.08.02.00 201-2186-121-20061213) with ESMTP id <20070821213603.BADW11829.mtao02.charter.net@aa02.charter.net>; Tue, 21 Aug 2007 17:36:03 -0400 Received: from [10.0.1.2] (really [66.188.165.91]) by aa02.charter.net with ESMTP id <20070821213603.SRWP26124.aa02.charter.net@[10.0.1.2]>; Tue, 21 Aug 2007 17:36:03 -0400 In-Reply-To: References: Mime-Version: 1.0 (Apple Message framework v752.2) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Cc: Content-Transfer-Encoding: 7bit From: Michael Glaesemann Subject: Re: Autovacuum is running forever Date: Tue, 21 Aug 2007 16:35:57 -0500 To: "Sachchida Ojha" X-Mailer: Apple Mail (2.752.2) X-Chzlrs: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/215 X-Sequence-Number: 26345 On Aug 21, 2007, at 16:26 , Sachchida Ojha wrote: > In my OLTP system, we are inserting, updating and deleting the data > every second. > > Autovacuum started and never finished slowing down the whole system. There's the possibility that your autovacuum settings aren't aggressive enough for your system, so it's never able to catch up. Without knowing details it's hard to say for certain. What are your autovacuum settings and other details about the load on your system? Michael Glaesemann grzm seespotcode net