Thread: pgavd status

pgavd status

From
"Brandon Metcalf"
Date:
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

Re: pgavd status

From
Douglas McNaught
Date:
"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

Re: pgavd status

From
"Brandon Metcalf"
Date:
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

Re: pgavd status

From
"Matthew T. O'Connor"
Date:
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.

Re: pgavd status

From
Douglas McNaught
Date:
"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

Re: pgavd status

From
Chris Browne
Date:
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/>