Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 30A059F9A0A for ; Tue, 21 Aug 2007 18:26:51 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 08329-06 for ; Tue, 21 Aug 2007 18:26:44 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from smtp.icemail.com (unknown [66.117.50.180]) by postgresql.org (Postfix) with ESMTP id BEF4B9F95AF for ; Tue, 21 Aug 2007 18:26:47 -0300 (ADT) Received: from EXVS01.IceMAIL.com ([10.2.23.110] RDNS failed) by smtp.icemail.com with Microsoft SMTPSVC(6.0.3790.3959); Tue, 21 Aug 2007 17:23:08 -0400 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C7E439.78927AEB" Subject: Autovacuum is running forever Date: Tue, 21 Aug 2007 17:26:45 -0400 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Autovacuum is running forever Thread-Index: AcfkOfnMqFIyu1ANQn6u6+5v5KgCuw== From: "Sachchida Ojha" To: X-OriginalArrivalTime: 21 Aug 2007 21:23:08.0931 (UTC) FILETIME=[78809530:01C7E439] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/213 X-Sequence-Number: 26343 This is a multi-part message in MIME format. ------_=_NextPart_001_01C7E439.78927AEB Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable Is there any way to stop the autovacuum if it is running longer than 10 min or so?=20 =20 Is it good idea to kill autovacuum if it is running longer than expected? =20 =20 In my OLTP system, we are inserting, updating and deleting the data every second.=20 =20 Autovacuum started and never finished slowing down the whole system. =20 =20 Any help? =20 Thanks Regards sachi ------_=_NextPart_001_01C7E439.78927AEB Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable

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.

 

 

Any help?

 

Thanks

Regards

sachi

------_=_NextPart_001_01C7E439.78927AEB--