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.

Just curious

Magnus Naeslund




Fri, 27 Apr 2001 06:10:44 +0200
"Magnus Naeslund\(f\)" <mag@fbab.net>
7.1 vacuum
* 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/

-- 
-Alfred Perlstein - [alfred@freebsd.org]
Instead of asking why a piece of software is using "1970s technology,"
start asking why software is ignoring 30 years of accumulated wisdom.

Thu, 26 Apr 2001 23:54:39 -0700
Alfred Perlstein <bright@wintelcom.net>
Re: 7.1 vacuum
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?

Fri, 27 Apr 2001 08:54:43 -0400
mlw <markw@mohawksoft.com>
Re: 7.1 vacuum
* 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/

Fri, 27 Apr 2001 05:55:17 -0700
Alfred Perlstein <bright@wintelcom.net>
Re: 7.1 vacuum
> > 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.

Vadim never got to merging into the 7.1 tree.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Fri, 27 Apr 2001 11:28:18 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Re: 7.1 vacuum