Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 211586E08E2 for ; Mon, 12 Dec 2011 10:26:01 -0400 (AST) Received: from mail-gy0-f174.google.com ([209.85.160.174]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Ra6pN-0004Lf-AP for pgsql-performance@postgresql.org; Mon, 12 Dec 2011 14:26:01 +0000 Received: by ghbf1 with SMTP id f1so1031935ghb.19 for ; Mon, 12 Dec 2011 06:25:48 -0800 (PST) Received: by 10.236.173.131 with SMTP id v3mr26070190yhl.112.1323699948605; Mon, 12 Dec 2011 06:25:48 -0800 (PST) Received: from AnibalVAIO ([200.85.32.68]) by mx.google.com with ESMTPS id 32sm50671588ant.12.2011.12.12.06.25.45 (version=TLSv1/SSLv3 cipher=OTHER); Mon, 12 Dec 2011 06:25:47 -0800 (PST) From: "Anibal David Acosta" To: Subject: autovacuum, exclude table Date: Mon, 12 Dec 2011 11:25:43 -0300 Message-ID: <00f501ccb8d9$f07dc4d0$d1794e70$@devshock.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00F6_01CCB8C0.CB317730" X-Mailer: Microsoft Outlook 14.0 Thread-Index: Acy42TEV8ee6/+4QQFKfYl2lMw+Rlg== Content-Language: es-py X-Pg-Spam-Score: -0.7 (/) X-Archive-Number: 201112/91 X-Sequence-Number: 45890 This is a multipart message in MIME format. ------=_NextPart_000_00F6_01CCB8C0.CB317730 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit I have a couple of tables with about 400millions of records increasing about 5 millions per day. I think that disabling autovac over those tables, and enabling daily manual vacuum (in some idle hour) will be better. I am right? Is possible to exclude autovacuum over some tables? Thanks! Anibal ------=_NextPart_000_00F6_01CCB8C0.CB317730 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I have a = couple of tables with about 400millions of records increasing about 5 = millions per day.

I think that = disabling autovac over those tables, and enabling daily manual vacuum = (in some idle hour) will be better.

I am = right?

Is possible to exclude autovacuum over some = tables?

Thanks!

Anibal

------=_NextPart_000_00F6_01CCB8C0.CB317730--