Re: 7.1 vacuum - Mailing list pgsql-hackers

From mlw
Subject Re: 7.1 vacuum
Date
Msg-id 3AE96C13.426A11C7@mohawksoft.com
Whole thread Raw
In response to 7.1 vacuum  ("Magnus Naeslund\(f\)" <mag@fbab.net>)
Responses Re: 7.1 vacuum  (Alfred Perlstein <bright@wintelcom.net>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: 7.1 startup recovery failure
Next
From: Alfred Perlstein
Date:
Subject: Re: 7.1 vacuum