Re: 7.1 vacuum
От | mlw |
---|---|
Тема | Re: 7.1 vacuum |
Дата | |
Msg-id | 3AE96C13.426A11C7@mohawksoft.com обсуждение исходный текст |
Ответ на | 7.1 vacuum ("Magnus Naeslund\(f\)" <mag@fbab.net>) |
Ответы |
Re: 7.1 vacuum
|
Список | pgsql-hackers |
Alfred Perlstein wrote: > > * Magnus Naeslund(f) <mag@fbab.net> [010426 21:17] wrote: > > How does 7.1 work now with the vacuum and all? > > > > Does it go for indexes by default, even when i haven't run a vacuum at all? > > Does vacuum lock up postgres? It says the analyze part shouldn't, but how's > > that for all of the vacuum? > > > > An 7.0.3 db we have here we are forced to run vacuum every hour to get an > > acceptable speed, and while doing that vacuum (5-10 minutes) it totaly > > blocks our application that's mucking with the db. > > http://people.freebsd.org/~alfred/vacfix/ What's the deal with vacuum lazy in 7.1? I was looking forward to it. It was never clear whether or not you guys decided to put it in. If it is in as a feature, how does one use it? If it is a patch, how does one get it? If it is neither a patch nor an existing feature, has development stopped?
В списке pgsql-hackers по дате отправления: