Isabella Ghiurea <isabella(dot)ghiurea(at)nrc-cnrc(dot)gc(dot)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
In response to
pgsql-admin by date
|Next:||From: Craig Ringer||Date: 2012-07-05 06:33:50|
|Subject: Re: Delay in completion of aggregation inserts when run in
a single commit - PG 9.1.2|
|Previous:||From: Isabella Ghiurea||Date: 2012-07-04 19:30:56|
|Subject: auto vacuum errors|