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
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 |