Thread

1. 7.1 vacuum

   Magnus Naeslund(f) <mag@fbab.net> — 2001-04-27T04:10:44Z

   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
   
   
   
   
   

2. Re: 7.1 vacuum

   Alfred Perlstein <bright@wintelcom.net> — 2001-04-27T06:54:39Z

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

3. Re: 7.1 vacuum

   mlw <markw@mohawksoft.com> — 2001-04-27T12:54:43Z

   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?
   
   

4. Re: 7.1 vacuum

   Alfred Perlstein <bright@wintelcom.net> — 2001-04-27T12:55:17Z

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

5. Re: Re: 7.1 vacuum

   Bruce Momjian <pgman@candle.pha.pa.us> — 2001-04-27T15:28:18Z

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