Csaba Nagy <nagy@xxxxxxxxxxxxxx> 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