Re: 7.1 vacuum - Mailing list pgsql-hackers

From Alfred Perlstein
Subject Re: 7.1 vacuum
Date
Msg-id 20010427055516.X18676@fw.wintelcom.net
Whole thread Raw
In response to Re: 7.1 vacuum  (mlw <markw@mohawksoft.com>)
Responses Re: Re: 7.1 vacuum  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
* mlw <markw@mohawksoft.com> [010427 05:50] wrote:
> 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 you actually download and read the enclosed READMEs it's pretty
clear.

> If it is neither a patch nor an existing feature, has development stopped?

I have no idea, I haven't been tracking postgresql all that much 
since leaving the place where we contracted that work.


-- 
-Alfred Perlstein - [alfred@freebsd.org]
Represent yourself, show up at BABUG http://www.babug.org/


pgsql-hackers by date:

Previous
From: mlw
Date:
Subject: Re: 7.1 vacuum
Next
From: Bruce Momjian
Date:
Subject: Re: Re: 7.1 vacuum