Re: What to do about a vacuum...

Поиск
Список
Период
Сортировка
От Robert M. Meyer
Тема Re: What to do about a vacuum...
Дата
Msg-id 1028905179.28137.7.camel@skymaster
обсуждение исходный текст
Ответ на Re: What to do about a vacuum...  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: What to do about a vacuum...  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Well, 'kill -INT pid' doesn't seem to have worked.  This is 7.2.1.  We
really don't want to whack the system but we need to get back online...

Any other ideas?

Bob

On Fri, 2002-08-09 at 09:47, Tom Lane wrote:
> "Robert M. Meyer" <rmeyer@installs.com> writes:
> > IN my infinite wisdom, in an effort to resolve my performance problems,
> > I started a full vacuum of my database last night around 4:00AM.  It's
> > still running at 9;20AM and it has all of the tables locked.
>
> Huh?  Vacuum should only lock one table at a time.
>
> > Is it safe to cancel the query from inside pgmonitor?
>
> Yes, a SIGINT should be safe enough.  You'll lose the benefit of whatever
> vacuuming work has been done so far on the current table.
>
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
--
Robert M. Meyer
Sr. Network Administrator
DigiVision Satellite Services
14 Lafayette Sq, Ste 410
Buffalo, NY 14203-1904
(716)332-1451


В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: What to do about a vacuum...
Следующее
От: Tom Lane
Дата:
Сообщение: Re: What to do about a vacuum...