Re: Cleanly cancel a query.

Поиск
Список
Период
Сортировка
От Thalis A. Kalfigopoulos
Тема Re: Cleanly cancel a query.
Дата
Msg-id Pine.LNX.4.21.0106081703290.17741-100000@aluminum.cs.pitt.edu
обсуждение исходный текст
Ответ на Cleanly cancel a query.  (Dennis <dennis@zserve.com>)
Ответы Re: Cleanly cancel a query.  ("Thalis A. Kalfigopoulos" <thalis@cs.pitt.edu>)
Список pgsql-general
You can kill -TERM the postmaster that is executing the particular query.

cheers,
t.


On Fri, 8 Jun 2001, Dennis wrote:

> If I have a database running, and I see that
> there is a postmaster process taking 99.9% cpu.
>
> ie, a very large insert query.
>
> Is there a way to cleanly shut down that query from the client or admin
> side?
>
>
> -Thanks
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>


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

Предыдущее
От: Somazx Interesting
Дата:
Сообщение: Re: Can not pg_dumpall
Следующее
От: "Thalis A. Kalfigopoulos"
Дата:
Сообщение: Re: Cleanly cancel a query.