Re: vacuum process stuck - Mailing list pgsql-novice

From Tom Lane
Subject Re: vacuum process stuck
Date
Msg-id 8155.1054092646@sss.pgh.pa.us
Whole thread Raw
In response to Re: vacuum process stuck  (Doug Silver <dsilver@urchin.com>)
List pgsql-novice
Doug Silver <dsilver@urchin.com> writes:
>> Any suggestions?  I assume I absolutely should not kill the postgresql
>> process that is running the request, so what are some other options?

> 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!

FWIW, killing a vacuum isn't any more dangerous than killing anything
else.  It should just work...

            regards, tom lane

pgsql-novice by date:

Previous
From: "Richard Hall"
Date:
Subject: Functions calling Functions
Next
From: Herbie McDuck
Date:
Subject: nOOb Alert..Need some help..