Re: AutoVacuum on demand?
| От | Matthew T. O'Connor |
|---|---|
| Тема | Re: AutoVacuum on demand? |
| Дата | |
| Msg-id | 4559D60E.20607@zeut.net обсуждение исходный текст |
| Ответ на | Re: AutoVacuum on demand? (Csaba Nagy <nagy@ecircle-ag.com>) |
| Ответы |
Re: AutoVacuum on demand?
|
| Список | pgsql-general |
Csaba Nagy wrote: > [snip] > >> I think the idea is to edit the postgresql.conf file on the fly and send >> a SIGHUP to the postmaster. I haven't ever heard of anyone doing that, >> but I don't see any reason why it wouldn't work. >> > > It works, I did it for a while with the statement_timeout to change it > globally over night when admin tasks were running. For the > statement_timeout thing it wasn't optimal however, finally I had to > ditch the thing... but it can be done. I'm confused, what does statement timeout have to do with this? I was assuming you would edit "autovacuum = off" to "autovacuum = on" wouldn't that work?
В списке pgsql-general по дате отправления: