Re: Killing long-running queries

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Killing long-running queries
Дата
Msg-id 6445.1146612600@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Killing long-running queries  (Dan Harris <fbsd@drivefaster.net>)
Ответы Re: Killing long-running queries
Список pgsql-performance
Dan Harris <fbsd@drivefaster.net> writes:
> So, I have been searching for a way to kill an individual query.  I read
> in the mailing list archives that you could 'kill' the pid.  I've tried
> this a few times and more than once, it has caused the postmaster to
> die(!), terminating every query that was in process, even unrelated to
> that query.

You should be using SIGINT, not SIGTERM.

            regards, tom lane

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

Предыдущее
От: Bill Moran
Дата:
Сообщение: Re: Why so slow?
Следующее
От: "Tony Wasson"
Дата:
Сообщение: Re: Killing long-running queries