Re: 7.1 vacuum

From: mlw <markw(at)mohawksoft(dot)com>
To: Alfred Perlstein <bright(at)wintelcom(dot)net>
Cc: "Magnus Naeslund(f)" <mag(at)fbab(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: 7.1 vacuum
Date: 2001-04-27 12:54:43
Message-ID: 3AE96C13.426A11C7@mohawksoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Alfred Perlstein wrote:
>
> * Magnus Naeslund(f) <mag(at)fbab(dot)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?

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alfred Perlstein 2001-04-27 12:55:17 Re: 7.1 vacuum
Previous Message Tom Lane 2001-04-27 12:46:03 Re: 7.1 startup recovery failure