| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec> |
| Cc: | POSTGRES <pgsql-es-ayuda(at)postgresql(dot)org> |
| Subject: | Re: [HACKERS] autovaccum can be disabled? |
| Date: | 2008-12-17 15:22:14 |
| Message-ID: | 20081217152214.GC4453@alvh.no-ip.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda |
Jaime Casanova escribió:
> Hi,
Estás en pgsql-es-ayuda
> 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?
Sí.
> 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
Es raro que sea un "automatic analyze" ... ¿estás seguro que la tabla es
la misma? Verifica el search_path.
--
Alvaro Herrera http://www.PlanetPostgreSQL.org/
"Find a bug in a program, and fix it, and the program will work today.
Show the program how to find and fix a bug, and the program
will work forever" (Oliver Silfridge)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alberto Rivera | 2008-12-17 16:00:42 | OT: Nuevo Proyecto LinuxChillan |
| Previous Message | Jaime Casanova | 2008-12-17 15:12:24 | [HACKERS] autovaccum can be disabled? |