Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 187409F9F8E for ; Tue, 21 Aug 2007 18:30:16 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 45016-05-2 for ; Tue, 21 Aug 2007 18:30:11 -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 F1E5C9F9FBC for ; Tue, 21 Aug 2007 18:30:10 -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:26:32 -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.F1DC53EE" Subject: Re: Autovacuum running forever Date: Tue, 21 Aug 2007 17:30:09 -0400 Message-ID: In-Reply-To: <46CB0979.7050104@Sun.COM> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [PERFORM] Autovacuum running forever Thread-Index: AcfkCshwxVV1uCFKRSua983jRy0XUQAL26AA From: "Sachchida Ojha" To: X-OriginalArrivalTime: 21 Aug 2007 21:26:32.0417 (UTC) FILETIME=[F1CA1510:01C7E439] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/214 X-Sequence-Number: 26344 This is a multi-part message in MIME format. ------_=_NextPart_001_01C7E439.F1DC53EE 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 =20 =20 ------_=_NextPart_001_01C7E439.F1DC53EE 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.F1DC53EE--