Обсуждение: 7.1 vacuum

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

* 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.

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?

* 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/

> > 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,
Pennsylvania19026
 

> 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?

I still had no time to port it to 7.1 -:(
I'll post message to -hackers when it will be ready.

Vadim