Thread: pgavd status
I've been looking at the auto vacuum daemon pgavd and it looks like there hasn't been any development activity in a while. Does anyone know that status of pgavd? Also, I'd be interested in hearing how well it works and if there are any plans to include this daemon in the pgsql distribution. -- Brandon
"Brandon Metcalf" <bmetcalf@nortel.com> writes: > I've been looking at the auto vacuum daemon pgavd and it looks like > there hasn't been any development activity in a while. Does anyone > know that status of pgavd? > > Also, I'd be interested in hearing how well it works and if there are > any plans to include this daemon in the pgsql distribution. You obviously just joined this list, as there's been extensive discussion of that very issue over the last few days. :) Take a look at the recent archives (and those for -hackers as well) but the upshot is that there is definitely a push to get AV integrated into the backend for 8.1. -Doug
d == doug@mcnaught.org writes: d> "Brandon Metcalf" <bmetcalf@nortel.com> writes: d> > I've been looking at the auto vacuum daemon pgavd and it looks like d> > there hasn't been any development activity in a while. Does anyone d> > know that status of pgavd? d> > d> > Also, I'd be interested in hearing how well it works and if there are d> > any plans to include this daemon in the pgsql distribution. d> You obviously just joined this list, as there's been extensive d> discussion of that very issue over the last few days. :) I've been subscribed for a while, but don't follow the messages actively. I apologize for asking the same thing again. d> Take a look at the recent archives (and those for -hackers as well) d> but the upshot is that there is definitely a push to get AV integrated d> into the backend for 8.1. Yeah, I did see some messages about it, but I guess I didn't look thoroughly enough. Thanks. -- Brandon
Douglas McNaught wrote: >"Brandon Metcalf" <bmetcalf@nortel.com> writes: > > > >>I've been looking at the auto vacuum daemon pgavd and it looks like >>there hasn't been any development activity in a while. Does anyone >>know that status of pgavd? >> >>Also, I'd be interested in hearing how well it works and if there are >>any plans to include this daemon in the pgsql distribution. >> >> > >You obviously just joined this list, as there's been extensive >discussion of that very issue over the last few days. :) > >Take a look at the recent archives (and those for -hackers as well) >but the upshot is that there is definitely a push to get AV integrated >into the backend for 8.1. > There has been extensive conversation in the last few days, however I think Brandon is referencing pgavd which is a project on gborg, which was an autovacuum implementation started by someone else that never took off. This is totally separate from pg_autovacuum that is in contrib. In my opinion that project is dead and could be removed.
"Matthew T. O'Connor" <matthew@zeut.net> writes: > There has been extensive conversation in the last few days, however I > think Brandon is referencing pgavd which is a project on gborg, which > was an autovacuum implementation started by someone else that never > took off. This is totally separate from pg_autovacuum that is in > contrib. > > In my opinion that project is dead and could be removed. OK, thanks for the correction--I wasn't aware of that project. -Doug
bmetcalf@nortel.com ("Brandon Metcalf") writes:
> I've been looking at the auto vacuum daemon pgavd and it looks like
> there hasn't been any development activity in a while. Does anyone
> know that status of pgavd?
The pgavd "tarball" has not been touched since September 2002.
http://cvsup.de.openbsd.org/pub/postgresql/projects/gborg/pgavd/devel/
pgavd.0.1.tar.gz 23-Sep-2002 15:31 343K
> Also, I'd be interested in hearing how well it works and if there
> are any plans to include this daemon in the pgsql distribution.
If there hasn't been a release in nearly three years, that might
suggest that it's a tad out of date. I haven't attempted a compile in
a couple of years, and I didn't have much success when I did try to do
so.
There is a somewhat analagous "pg_autovacuum" daemon that has been in
the contrib section of PostgreSQL since 7.4. It was not based on
pgavd.
There are plans to "put that down" in favor of an in-the-engine
autovacuumer, possibly in 8.1.
--
(format nil "~S@~S" "cbbrowne" "acm.org")
http://www.ntlug.org/~cbbrowne/sap.html
Rules of the Evil Overlord #78. "I will not tell my Legions of Terror
"And he must be taken alive!" The command will be: ``And try to take
him alive if it is reasonably practical.''"
<http://www.eviloverlord.com/>