Re: auto vacuum errors

Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca> writes:
> I'm seeing a issue with some temp tables in contrib_regression db , the
> auto vacuum job will not run for this tables  due some files/QID's
> missing  how can I fix this  ?

Um ... in general, autovacuum just silently ignores temp tables, because
it doesn't have any way to access their contents.  (One of the reasons
that temp tables are fast is that the backend owning a temp table keeps
its data in local buffers, not in shared buffers that another process
could access.)  I wouldn't expect any "missing file" complaints though.
What exactly were you seeing?

            regards, tom lane