Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id D36349FB5FD for ; Tue, 13 Feb 2007 11:55:43 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 10658-07 for ; Tue, 13 Feb 2007 11:55:21 -0400 (AST) X-Greylist: delayed 00:12:06.086035 by SQLgrey-1.7.4 Received: from boston.agmednet.com (boston.agmednet.com [74.92.47.82]) by postgresql.org (Postfix) with ESMTP id 07CFA9FB80C for ; Tue, 13 Feb 2007 11:55:20 -0400 (AST) X-MimeOLE: Produced By Microsoft Exchange V6.5 Received: from 71.233.123.244 ([71.233.123.244]) by agmednet-dc.boston.agmednet.local ([192.168.67.2]) with Microsoft Exchange Server HTTP-DAV ; Tue, 13 Feb 2007 15:34:32 +0000 User-Agent: Microsoft-Entourage/11.3.3.061214 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C74F84.758B45CC" Content-class: urn:content-classes:message Subject: Is it normal for Autovacuum running continuously? Date: Tue, 13 Feb 2007 10:34:32 -0500 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Is it normal for Autovacuum running continuously? Thread-Index: AcdPhYclxf5jnrt4EducdwAX8gFv1g== From: "Michael Goldner" To: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.011 tagged_above=0 required=5 tests=BAYES_50, FORGED_RCVD_HELO, HTML_30_40, HTML_MESSAGE, RCVD_NUMERIC_HELO X-Spam-Level: ** X-Archive-Number: 200702/176 X-Sequence-Number: 24641 This is a multi-part message in MIME format. ------_=_NextPart_001_01C74F84.758B45CC Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I notice in my postgres logfile that autovacuum is running every minute. The server had no overnight activity, yet this has been going on for = days. Overall performance of the database seems to be slow, and I assume that = it is related. I'm running 8.1.4 on Redhat EL4.3. Is this normal for autovacuum? Here is the tail of the log (even though it doesn't say much): [4836---2007-02-13 08:28:28.194 EST]LOG: autovacuum: processing = database "xx" [4859---2007-02-13 08:29:28.200 EST]LOG: autovacuum: processing = database "xx" [4863---2007-02-13 08:30:28.196 EST]LOG: autovacuum: processing = database "xx" [4865---2007-02-13 08:31:28.191 EST]LOG: autovacuum: processing = database "xx" [4870---2007-02-13 08:32:28.201 EST]LOG: autovacuum: processing = database "xx" [4916---2007-02-13 08:34:23.555 EST]LOG: autovacuum: processing = database "xx" [4921---2007-02-13 08:35:23.550 EST]LOG: autovacuum: processing = database "xx" [4923---2007-02-13 08:36:23.555 EST]LOG: autovacuum: processing = database "xx" [4959---2007-02-13 08:37:27.169 EST]LOG: autovacuum: processing = database "xx" [4965---2007-02-13 08:38:27.165 EST]LOG: autovacuum: processing = database "xx" [5057---2007-02-13 08:39:27.178 EST]LOG: autovacuum: processing = database "xx" Thanks, Mike ------_=_NextPart_001_01C74F84.758B45CC Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Is it normal for Autovacuum running continuously?

I notice in my postgres logfile that autovacuum is = running every minute.
The server had no overnight activity, yet this has been going on for = days.
Overall performance of the database seems to be slow, and I assume that = it
is related.

I'm running 8.1.4 on Redhat EL4.3.

Is this normal for autovacuum?

Here is the tail of the log (even though it doesn't say much):

[4836---2007-02-13 08:28:28.194 EST]LOG:  autovacuum: processing = database
"xx"
[4859---2007-02-13 08:29:28.200 EST]LOG:  autovacuum: processing = database
"xx"
[4863---2007-02-13 08:30:28.196 EST]LOG:  autovacuum: processing = database
"xx"
[4865---2007-02-13 08:31:28.191 EST]LOG:  autovacuum: processing = database
"xx"
[4870---2007-02-13 08:32:28.201 EST]LOG:  autovacuum: processing = database
"xx"
[4916---2007-02-13 08:34:23.555 EST]LOG:  autovacuum: processing = database
"xx"
[4921---2007-02-13 08:35:23.550 EST]LOG:  autovacuum: processing = database
"xx"
[4923---2007-02-13 08:36:23.555 EST]LOG:  autovacuum: processing = database
"xx"
[4959---2007-02-13 08:37:27.169 EST]LOG:  autovacuum: processing = database
"xx"
[4965---2007-02-13 08:38:27.165 EST]LOG:  autovacuum: processing = database
"xx"
[5057---2007-02-13 08:39:27.178 EST]LOG:  autovacuum: processing = database
"xx"

Thanks,

Mike

------_=_NextPart_001_01C74F84.758B45CC--