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
--
TIP 10: no uses HTML en tu pregunta, seguro que quien responda no podrá leerlo
