[HACKERS] autovaccum can be disabled?

From: "Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)ec>
To: POSTGRES <pgsql-es-ayuda(at)postgresql(dot)org>
Subject: [HACKERS] autovaccum can be disabled?
Date: 2008-12-17 15:12:24
Message-ID: 3073cc9b0812170712o1ef9163bx55936274e4de8351@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

Hi,

AFAIK, if add a line in pg_autovaccum with the oid of a table and with
enabled false the autovacuum will do nothing for the table that has
that oid.

Is that right?

mic=# select vacrelid, enabled from pg_autovacuum;
vacrelid | enabled
----------+---------
28212 | f
(1 row)

mic=# select vacrelid::regclass, enabled from pg_autovacuum;
vacrelid | enabled
-----------------+---------
tcom_invitacion | f
(1 row)

Nevertheless, i'm seeing this in the logs:

LOG: automatic analyze of table "mic.public.tcom_invitacion" system
usage: CPU 0.00s/0.04u sec elapsed 0.04 sec

Is this normal?
BTW, we execute a general vacuum on all tables at midnight

--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Alvaro Herrera 2008-12-17 15:22:14 Re: [HACKERS] autovaccum can be disabled?
Previous Message (Syswarp) Carlos Enrique Perez 2008-12-16 20:41:51 RE: Sobre uso de Mondrian