Re: pg_autovacuum crashes when query fails for temp

> Bruce Momjian wrote:
> Should pg_autovacuum be vacuuming temporary tables?

This is a good question, and I would like some opinions from some other
people more informed than I.

> Secondly, why would
> a temporary table for another session be visible to pg_autovacuum? I
> know these may sound like stupid questions, but I'm a little shocked
> that it found a temp table. Did someone make a permanent table, delete
> it, and pg_autovacuum found it in between those operations?

I will look into this when I have time, it certainly would be possible
that pg_autovacuum could be tripped up by a sequence of events like you
describe above. The more general problem is that it shouldn't crash even
if it's vacuuming tables it shouldn't.

Matthew