Re: autovacuum and temporary tables

Exactly which version of 8.0.x? There was a bug fixed around 8.0.5 or
so "Prevent core dump in contrib version of autovacuum when a table has
been dropped. Per report from daveg (not his patch, though)."

The version of autovacuum in 8.1 is a fairly different beast than the
contrib version, and since it was integrated, I think all of Tom's
concerns were dealt with. I highly recommend the 8.1 version over the
contrib version for many reason.

Matt

Csaba Nagy wrote:
> Hi all,
>
> I have a postgres 8.0 installation, and I'm running autovacuum against
> it. I have noticed that it processes temporary tables too, which is in
> itself a bit curious, but the problem is that autovacuum might even
> crash if a temporary table is suddenly gone while it tries to vacuum
> it... that's what happened once here. I'm not sure what are the
> necessary conditions to trigger this, it only happened once.
>
> I searched in the release notes and googled a bit, but could not
> (quickly) find what's the status of autovacuum vs. temporary tables in
> 8.1. I have seen that that was one of Tom's outstanding issues with
> autovacuum to be included in the core, but was this resolved ?
>
> Thanks,
> Csaba.
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>