Re: Killing the backend to cancel a long waiting query

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Paulo Scardine" <paulos(at)cimed(dot)ind(dot)br>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Killing the backend to cancel a long waiting query
Date: 2003-09-18 19:54:10
Message-ID: 1850.1063914850@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-interfaces pgsql-odbc

"Paulo Scardine" <paulos(at)cimed(dot)ind(dot)br> writes:
>> I trust when you say "kill", you really mean "send SIGINT" ...

> I'm sending a SIGTERM. Would SIGINT be more appropriate?

Yes --- that would actually cancel the query, not cause the backend to
shut down.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-09-18 20:24:05 Re: 7.4beta2 vs 7.3.3
Previous Message Gaetano Mendola 2003-09-18 19:28:53 7.4beta2 vs 7.3.3

Browse pgsql-interfaces by date

  From Date Subject
Next Message Hiroshi Inoue 2003-09-18 23:46:13 Re: [HACKERS] Killing the backend to cancel a long waiting query
Previous Message Paulo Scardine 2003-09-18 19:19:48 Re: Killing the backend to cancel a long waiting query

Browse pgsql-odbc by date

  From Date Subject
Next Message Richard Combs 2003-09-18 20:29:38 Re: Delphi7, ADO, ODBC and PostgreSQL connection problems:
Previous Message Paulo Scardine 2003-09-18 19:19:48 Re: Killing the backend to cancel a long waiting query