[GENERAL] Stuck in a vacuum.

Dear all,

I started did the following on a table (blast_hits) with approximately
400,000 rows:

BEGIN;
UPDATE blast_hits SET hit_id=hit_id+400000 WHERE hit_id<=208611;

this was taking much too long (and I realised it was useless anyway)... so
aborted with Control C).

then did an END;

QUESTION 1: there was an index on hit_id (and on two other fields in this
table of five fields) should I have delete a) the one on hit_it, b) all of
them or c) none of them before trying the update?

Since I thought that probably left the table a bit messed up, I started a:

VACUUM blast_hits;

It's using 95% of the cpu and seems to be going nowhere (at least not in
the 30 minutes it has been running so far).

QUESTION 2: What do I do now? Is there any way I can kill the VACUUM or
will they be the final nail in the table's coffin?

please help as my teeth are begining to suffer from extensive gnashing!

S.

+-------------------------+--------------------------------------+
| Stuart Rison | Ludwig Institute for Cancer Research |
+-------------------------+ 91 Riding House Street |
| Tel. (0171) 878 4041 | London, W1P 8BT, UNITED KINGDOM. |
| Fax. (0171) 878 4040 | stuart(at)ludwig(dot)ucl(dot)ac(dot)uk |
+-------------------------+--------------------------------------+