vacuum process stuck

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-novice by date

  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