I am running PostgreSQL 7.2.1 on a Sun 5.8 OS. I have a database named metrics with 4 tables. A few of the tables contain approx. 10 million records. When I run a vaccuum/analyze with the following command:
vacuumdb -d metrics -z -v
the process 'hangs' for several hours and then an error message appears that says:
vacuumdb: vacuum metrics failed.
ERROR: RelationClearRelation: Relation 16599 deleted while still in use.
Watching the stdout I see the process is 'hanging' on analyzing one of my tables called file_dup. This table has no data in it. What strikes me as odd is that I ran vacuumdb against the file_dup table itself:
(vacuumdb -z -v -t 'file_dup' metrics) and it completed within seconds without errors.
I tried to run the vacuumdb against the entire database again and it 'hung' in the same place.
Any suggestions?
Jeff Brickley