Re: autovacuum not running
От | Ben |
---|---|
Тема | Re: autovacuum not running |
Дата | |
Msg-id | Pine.LNX.4.64.0708281505270.17514@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: autovacuum not running (Alvaro Herrera <alvherre@commandprompt.com>) |
Ответы |
Re: autovacuum not running
Re: autovacuum not running Re: autovacuum not running |
Список | pgsql-general |
Hm, I assumed it wasn't running because pg_stat_all_tables shows the last vacuum from several weeks ago, and this is an active db. Also, I see no vacuum activity in the logs. But "show autovacuum" does show it being on.... So if it is running after all, how can I track down why things aren't getting vacuumed? What log level are the autovacuum logs at? On Tue, 28 Aug 2007, Alvaro Herrera wrote: > Ben wrote: >> My autovacuum daemon isn't running on 8.2.4, and I'm guessing it's because >> I changed my unix socket directory in postgresql.conf. Is there a way I can >> tell autovacuum which socket file to use, or which IP to connect to? > > It doesn't use a socket. How do you know it's not running? An easy > test is connect with psql and do a "show autovacuum". If it's on, then > it is running. > > -- > Alvaro Herrera http://www.amazon.com/gp/registry/CTMLCN8V17R4 > "El número de instalaciones de UNIX se ha elevado a 10, > y se espera que este número aumente" (UPM, 1972) >
В списке pgsql-general по дате отправления: