Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 9F2A16E08E4 for ; Mon, 12 Dec 2011 10:55:20 -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 1Ra7Hj-0004lz-J7 for pgsql-performance@postgresql.org; Mon, 12 Dec 2011 14:55:20 +0000 Received: by ghbf1 with SMTP id f1so1059047ghb.19 for ; Mon, 12 Dec 2011 06:55:07 -0800 (PST) Received: by 10.236.193.70 with SMTP id j46mr25605106yhn.108.1323701705476; Mon, 12 Dec 2011 06:55:05 -0800 (PST) Received: from AnibalVAIO ([200.85.32.68]) by mx.google.com with ESMTPS id d5sm31000950yhl.19.2011.12.12.06.55.02 (version=TLSv1/SSLv3 cipher=OTHER); Mon, 12 Dec 2011 06:55:04 -0800 (PST) From: "Anibal David Acosta" To: "'Craig Ringer'" Cc: References: <00f501ccb8d9$f07dc4d0$d1794e70$@devshock.com> In-Reply-To: Subject: Re: autovacuum, exclude table Date: Mon, 12 Dec 2011 11:55:00 -0300 Message-ID: <010a01ccb8de$07c0ad20$17420760$@devshock.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_010B_01CCB8C4.E27549E0" X-Mailer: Microsoft Outlook 14.0 Thread-Index: AQGkUYcacb18vEnKcZx6PE9iGoSoXgHRkFW0lhqKykA= Content-Language: es-py X-Pg-Spam-Score: -2.6 (--) X-Archive-Number: 201112/93 X-Sequence-Number: 45892 This is a multipart message in MIME format. ------=_NextPart_000_010B_01CCB8C4.E27549E0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable The postgres version is 9.0.4 on a Windows Server 2008 (planning to = upgrade to 9.1) Tables has insert (in bulk every 3 minutes) and delete one per day = (delete records older than XX days) =20 There are not much additional relevant information. =20 Thanks! =20 =20 De: Craig Ringer [mailto:ringerc@ringerc.id.au]=20 Enviado el: lunes, 12 de diciembre de 2011 11:45 a.m. Para: Anibal David Acosta CC: pgsql-performance@postgresql.org Asunto: Re: [PERFORM] autovacuum, exclude table =20 Top-posting because this is context free: You need to provide more info for anybody to help you. Are the tables = append-only or are deletes/updates also performed? Also this: http://wiki.postgresql.org/wiki/Guide_to_reporting_problems On Dec 12, 2011 10:26 PM, "Anibal David Acosta" wrote: I have a couple of tables with about 400millions of records increasing = about 5 millions per day. =20 I think that disabling autovac over those tables, and enabling daily = manual vacuum (in some idle hour) will be better. =20 I am right? =20 Is possible to exclude autovacuum over some tables? =20 Thanks! =20 Anibal ------=_NextPart_000_010B_01CCB8C4.E27549E0 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

The postgres version is 9.0.4 on a Windows Server 2008 (planning to = upgrade to 9.1)

Tables has insert (in bulk every 3 minutes) and delete one per day = (delete records older than XX days)

 

There are not much additional relevant = information.

 

Thanks!

 

 

De: Craig = Ringer [mailto:ringerc@ringerc.id.au]
Enviado el: lunes, 12 = de diciembre de 2011 11:45 a.m.
Para: Anibal David = Acosta
CC: pgsql-performance@postgresql.org
Asunto: = Re: [PERFORM] autovacuum, exclude table

 

Top-posting because this is = context free:

You need to provide more info for anybody = to help you. Are the tables append-only or are deletes/updates also = performed? Also this:

http= ://wiki.postgresql.org/wiki/Guide_to_reporting_problems

On Dec 12, 2011 10:26 PM, "Anibal David = Acosta" <aa@devshock.com> = wrote:

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

 <= /o:p>

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

 <= /o:p>

I am = right?

 <= /o:p>

Is possible = to exclude autovacuum over some tables?

 <= /o:p>

Thanks!=

 <= /o:p>

Anibal<= /o:p>

------=_NextPart_000_010B_01CCB8C4.E27549E0--