Vaccuum/Analyze
| От | Brickley Jeff-RA9607 |
|---|---|
| Тема | Vaccuum/Analyze |
| Дата | |
| Msg-id | 7146D19B7FC9D5119F6400D0B7B993080318C9CF@az33exm22.corp.mot.com обсуждение исходный текст |
| Ответы |
Re: Vaccuum/Analyze
|
| Список | pgsql-admin |
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
В списке pgsql-admin по дате отправления: