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@icr.com.au
Independent Computer Retailers (ICR)               http://www.icr.com.au
ICRnet                               http://www.icr.net.au