Csaba Nagy <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
