Re: [ADMIN] auto vacuum errors

2012-07-05 Thread Tom Lane
Isabella Ghiurea writes: > Here is my error , the missing files were removed by mistake , I have > another similar db cfg with this tables:spherrtmp% and no issues. > I 'm thinking to restore this tables content from this second db , > will this eliminate the auto vacuum error ? What you

Re: [ADMIN] auto vacuum errors

2012-07-05 Thread Isabella Ghiurea
Hi Tom , Here is my error , the missing files were removed by mistake , I have another similar db cfg with this tables:spherrtmp% and no issues. I 'm thinking to restore this tables content from this second db , will this eliminate the auto vacuum error ? 07:45:59.770 PDT,,,31112,,4ff5a8a

Re: [ADMIN] auto vacuum errors

2012-07-04 Thread Tom Lane
Isabella Ghiurea 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

[ADMIN] auto vacuum errors

2012-07-04 Thread Isabella Ghiurea
HI Gurus 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 ? The temp tables are growing too fast and they don't get empty/clean-up...any tips ? I 'm running PGSQL 8.3.6 on RH