Re: [HACKERS] Function to kill backend - Mailing list pgsql-patches

From Oliver Jowett
Subject Re: [HACKERS] Function to kill backend
Date
Msg-id 41057619.90000@opencloud.com
Whole thread Raw
In response to Re: [HACKERS] Function to kill backend  (Andreas Pflug <pgadmin@pse-consulting.de>)
Responses Re: [HACKERS] Function to kill backend  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
Andreas Pflug wrote:
> Tom Lane wrote:
>
>>
>> If you don't mind plastering a "use at your own risk" sign on it, then
>> go for it.
>
>
> killing a backend is obviously much more "at your own risk" than a
> descent function.
>

[...]

What about implementing "kill" as "cancel then exit"? Does that
guarantee a safe exit in all cases?

It wouldn't catch *all* the cases where you want to kill a backend, just
the ones where the backend is in a cancellable state, but it seems to me
that the main usecase is killing an otherwise idle backend that the
client doesn't want to let go of. And if the backend isn't cancellable
for an extended period, you probably have other problems anyway.

-O

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: win32 version info
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Function to kill backend