Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 587712E3157 for ; Mon, 17 Mar 2008 11:37:09 -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 28952-01-3 for ; Mon, 17 Mar 2008 11:36:36 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail.autorevenue.com (ip-208.178.167.106.gblx.net [208.178.167.106]) by postgresql.org (Postfix) with ESMTP id EC3AB2E07DD for ; Mon, 17 Mar 2008 11:31:26 -0300 (ADT) Received: (qmail 20573 invoked from network); 17 Mar 2008 10:32:56 -0400 Received: from unknown (HELO dei26g028575) (msteben@10.10.1.20) by mail.autorevenue.com with SMTP; 17 Mar 2008 10:32:56 -0400 From: "Mark Steben" To: Subject: auto_vacuum question Date: Mon, 17 Mar 2008 10:31:02 -0400 Message-ID: <004a01c8883b$86b9f140$14010a0a@dei26g028575> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_004B_01C88819.FFA85140" X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2992 Thread-Index: AciIO4aupkFCI+uBTUmaBPL3uQuP/A== X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/122 X-Sequence-Number: 28605 This is a multi-part message in MIME format. ------=_NextPart_000_004B_01C88819.FFA85140 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit We upgraded from postgres 7.4.5 to 8.2.5 a couple weekends ago. I just turned auto vacuum on today. I manually inserted 4 entries in PG_AUTOVACUUM with enabled = 'f' to exclude these larger tables That we manually vacuum every night. But the first tables that autovacuum chooses to vacuum are These 4 tables. Am I missing something? Another, possibly related question: the 4 tables mentioned above are vacuumed via a scheduled Daemon that invokes the VACUUMDB shell. But the LAST_VACUUM column in PG_STAT_USER_TABLES Is not updated to reflect this vacuum. Other tables vacuumed manually during the day do have this LAST_VACUUM column updated. The autovacuum does populate the LAST_AUTOVACUUM column For these tables. Any insights? Thanks Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480 Pleasant Street Suite B200 Lee, MA 01238 413-243-4800 Home Office 413-243-4809 Corporate Fax msteben @autorevenue.com Visit our new website at www.autorevenue.com IMPORTANT: The information contained in this e-mail message is confidential and is intended only for the named addressee(s). If the reader of this e-mail message is not the intended recipient (or the individual responsible for the delivery of this e-mail message to the intended recipient), please be advised that any re-use, dissemination, distribution or copying of this e-mail message is prohibited. If you have received this e-mail message in error, please reply to the sender that you have received this e-mail message in error and then delete it. Thank you. ------=_NextPart_000_004B_01C88819.FFA85140 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

We upgraded from postgres 7.4.5 to 8.2.5 a couple weekends = ago. I just turned auto vacuum on today.

I manually inserted 4 entries in PG_AUTOVACUUM with enabled =3D = ‘f’ to exclude these larger tables

That we manually vacuum every night. But the first tables = that autovacuum chooses to vacuum are

These 4 tables. Am I missing = something?

Another, possibly related question: the 4 tables mentioned = above are vacuumed via a scheduled

Daemon that invokes the VACUUMDB shell. But the = LAST_VACUUM column in PG_STAT_USER_TABLES

Is not updated to reflect this vacuum. Other tables = vacuumed manually during the day do have this

LAST_VACUUM column updated. The autovacuum does populate = the LAST_AUTOVACUUM column

For these tables.

Any insights? Thanks

Mark Steben

Senior Database Administrator
@utoRevenue™
A Dominion = Enterprises Company
480 = Pleasant Street
Suite = B200
Lee, MA 01238
413-243-4800 Home Office
413-243-4809 Corporate Fax

msteben@autorevenue.com

Visit our = new website at
www.autorevenue.com

IMPORTANT: The information = contained in this e-mail message is confidential and is intended only for the named addressee(s). If the reader of this e-mail message is not the intended recipient (or the individual responsible for the delivery of this e-mail message to the intended recipient), please be advised that any re-use, dissemination, distribution or copying of this e-mail message is = prohibited. If you have received this e-mail message in error, please reply to = the sender that you have received this e-mail message in error and then = delete it. Thank you.

------=_NextPart_000_004B_01C88819.FFA85140--