Re: vacuum process stuck

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Doug Silver <dsilver(at)urchin(dot)com>
Cc: "pgsql-novice" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: vacuum process stuck
Date: 2003-05-28 03:30:46
Message-ID: 8155.1054092646@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Doug Silver <dsilver(at)urchin(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Herbie McDuck 2003-05-28 09:28:02 nOOb Alert..Need some help..
Previous Message Richard Hall 2003-05-28 00:26:19 Functions calling Functions