Re: autovacuum and temporary tables - Mailing list pgsql-general

From Tom Lane
Subject Re: autovacuum and temporary tables
Date
Msg-id 17345.1137770591@sss.pgh.pa.us
Whole thread Raw
In response to autovacuum and temporary tables  (Csaba Nagy <nagy@ecircle-ag.com>)
List pgsql-general
Csaba Nagy <nagy@ecircle-ag.com> writes:
> 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.

8.0.what?  I'm wondering if you are missing this 8.0.5 fix:

2005-10-20 12:14  tgl

    * contrib/pg_autovacuum/pg_autovacuum.c (REL8_0_STABLE): Prevent
    core dump in contrib version of autovacuum when a table has been
    dropped.  Per report from daveg (not his patch, though).

            regards, tom lane

pgsql-general by date:

Previous
From: Csaba Nagy
Date:
Subject: Re: autovacuum and temporary tables
Next
From: Keary Suska
Date:
Subject: Re: How to fetch rows with multiple values