Re: vacuum taking long time

Dale Walker wrote:
>
> I have a machine inadvertently reboot on me this morning, and I have
> been running a vacuumdb command to try and check it.
>
> The vacuum command has processed the indexes OK, but it hasn't returned
> to a prompt as yet (3hrs)
>
> The table has only taken about 5min to do a vacuum on in the past... any
> suggestions??
>
> This is what I have on my screen so far...
> ------------------------------------------------------------------
<snipped>

I just bombed out 'postmaster' with a kill -9 , restarted and I'm in the
process of doing a pg_dump of the table.

I'll then drop the table, and re-create from the dump...

Should be OK??

The table was only created from radius log files anyway, so I can
recreate if I need to...

Anyone have any suggestions as too where I should start looking for what
went wrong??

--
Dale Walker dale(at)icr(dot)com(dot)au
Independent Computer Retailers (ICR) http://www.icr.com.au
ICRnet http://www.icr.net.au