From: | Doug Silver <dsilver(at)urchin(dot)com> |
---|---|
To: | "pgsql-novice" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: vacuum process stuck |
Date: | 2003-05-27 23:00:21 |
Message-ID: | 200305271559.59982.dsilver@urchin.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Tuesday 27 May 2003 02:55 pm, you wrote:
> I was attempting to clean up one of my databases and so I ran 'vacuum full'
> on the database. However, after at least an hour, it seemed stuck, so in
> the terminal window I hit CTR-C to cancel out of it, but it still hasn't
> quit (it said the following:
>
> # vacuum full;
> ^CCancel request sent
> ^CCancel request sent
> ^CCancel request sent
>
> When I run top, it says this process status is in 'biord', which according
> to the FreeBSD lists corresponds to buffers being read or written. So, how
> long should I wait for this process to finish? I know one of the tables in
> the db probably has ~20-30 million entries in it.
>
> Any suggestions? I assume I absolutely should not kill the postgresql
> process that is running the request, so what are some other options?
>
> TIA.
>
> -doug
>
> details - FBSD 4.8, postgres 7.3.2_1
FYI -
After another 45 minutes or so, it finally quit and I was able to restart
postgresql and run vacuum db. A little patience was the best thing in this
case!
-doug
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Hall | 2003-05-28 00:26:19 | Functions calling Functions |
Previous Message | Doug Silver | 2003-05-27 21:55:50 | vacuum process stuck |