Why the database vacuum doesn't work?

[HHLWX1]

I just do as the FAQ(http://faq.holdemmanager.com/questions/88/Vacuum+Analyze+Database+ ) says.
But when I do this vacuum,it works just one minute and end here,the information is as below:
CPU 0.00s/0.00u sec elapsed 0.00 sec.INFO: analyzing "public.notecaddy_metrics"INFO: "notecaddy_metrics": scanned 1 of 1 pages, containing 1 live rows and 0 dead rows; 1 rows in sample, 1 estimated total rowsINFO: vacuuming "public.handhistories"
it stops here and I wait and wait,but nothing happenes afterwards.So I have to click cancel.
What's wrong?P.S. My postgre is 8.3

[Patvs]

It looks like a corruption in the analyzing "public.notecaddy_metrics" index of the database.

Try reindexing the database in pgadminIII.

If that doesn't resolve it, create a new database and reimport your hands. If you'll be creating a new database, update PostgreSQL 8.3 to the latest version of 8.4 or 9.2.

[HHLWX1]

I have tried as your suggestion,but reindexing doesn't work.I want to know What's the difference between version 9.2 and my version 8.3?What good does version 9.2 have?How to update it?Thanks for your reply.

[Patvs]

If you have a 64 bit Windows (with 4+ GB RAM) there is a special 64 bit build of PostgreSQL 9.0 and 9.2.

Install PostgreSQL 9.2 with the manual installer from postgresql.org to port 5433.
Start HM2--> then create a new database, and change the port to 5433 at the 'add database' window.