Re: 7.1 vacuum - Mailing list pgsql-hackers

From Alfred Perlstein
Subject Re: 7.1 vacuum
Date
Msg-id 20010426235439.U18676@fw.wintelcom.net
Whole thread Raw
In response to 7.1 vacuum  ("Magnus Naeslund\(f\)" <mag@fbab.net>)
List pgsql-hackers
* 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.


pgsql-hackers by date:

Previous
From: "Vadim Mikheev"
Date:
Subject: Re: 7.1 startup recovery failure
Next
From: Lincoln Yeoh
Date:
Subject: Re: scaling multiple connections