Re: [HACKERS] Help with Vacuum Failure

2001-08-14 Thread Tom Lane
"Matthew T. O'Connor" <[EMAIL PROTECTED]> writes: > cms_beau=# vacuum hits; (It works without the analyze phase of backup.) > VACUUM > cms_beau=# VACUUM verbose analyze hits; > NOTICE: --Relation hits-- > NOTICE: Pages 8389: Changed 0, reaped 2, Empty 0, New 0; Tup 834575: Vac 0, > Keep/VTL 4/4

[HACKERS] Help with Vacuum Failure

2001-08-14 Thread Matthew T. O'Connor
Hello, I'm having a problem vacuum a table and I didn't see an answer using the fts engine. I have two questions: 1) Is this a big problem, can it be fixed, do I have to dump / restore this table? 2) I found this problem from my nightly cron driven vacuum -a -z. When it hits this error the enti