Re: Killing long-running queries - Mailing list pgsql-performance

From Tom Lane
Subject Re: Killing long-running queries
Date
Msg-id 6445.1146612600@sss.pgh.pa.us
Whole thread Raw
In response to Killing long-running queries  (Dan Harris <fbsd@drivefaster.net>)
Responses Re: Killing long-running queries
List 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 by date:

Previous
From: Bill Moran
Date:
Subject: Re: Why so slow?
Next
From: "Tony Wasson"
Date:
Subject: Re: Killing long-running queries