| From: | Doug Silver <dsilver(at)urchin(dot)com> |
|---|---|
| To: | "pgsql-novice" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | vacuum process stuck |
| Date: | 2003-05-27 21:55:50 |
| Message-ID: | 200305271455.28480.dsilver@urchin.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Doug Silver | 2003-05-27 23:00:21 | Re: vacuum process stuck |
| Previous Message | Jorge Ramirez | 2003-05-27 21:52:48 | Re: PHP vs Cold Fusion vs Zope |