Re: 7.1 vacuum
mlw <markw@mohawksoft.com>
From: mlw <markw@mohawksoft.com>
To: Alfred Perlstein <bright@wintelcom.net>
Cc: "Magnus Naeslund(f)" <mag@fbab.net>, pgsql-hackers@postgresql.org
Date: 2001-04-27T12:54:43Z
Lists: 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?