Stuart Rison wrote:
>
> 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?
VACUUM uses transactions so there shouldn't be problems with
its stopping.
After that try to drop all indices over blash_hits and re-vacuum
(in verbose mode).
BTW, PG version?
Vadim