Re: vacuum taking long time - Mailing list pgsql-general

From Dale Walker
Subject Re: vacuum taking long time
Date
Msg-id 39C1B1F0.703614B4@icr.com.au
Whole thread Raw
In response to vacuum taking long time  (Dale Walker <dale@icr.com.au>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Corrupt Table - Gettting Desparate
Next
From: Andreas Tille
Date:
Subject: RE: Error in servlet