From: | Dale Walker <dale(at)icr(dot)com(dot)au> |
---|---|
To: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: vacuum taking long time |
Date: | 2000-09-15 05:21:52 |
Message-ID: | 39C1B1F0.703614B4@icr.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)icr(dot)com(dot)au
Independent Computer Retailers (ICR) http://www.icr.com.au
ICRnet http://www.icr.net.au
From | Date | Subject | |
---|---|---|---|
Next Message | Dronamraju Rajesh | 2000-09-15 06:18:41 | libpq errors when makeing postgres 7.0.2... |
Previous Message | Tom Lane | 2000-09-15 02:25:32 | Re: Corrupt Table - Gettting Desparate |