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

From Andreas Pflug
Subject Re: [HACKERS] Function to kill backend
Date
Msg-id 410416C8.8010804@pse-consulting.de
Whole thread Raw
In response to Re: [HACKERS] Function to kill backend  ("Magnus Hagander" <mha@sollentuna.net>)
Responses Re: [HACKERS] Function to kill backend
List pgsql-patches
>>Would you use a kill operation in the way you describe above
>>if you knew
>>that it had, say, a 1% chance of causing a database-wide PANIC
>>each time
>>you used it?

Seems there's the need for some connection killing functionality. If
it's not present, the whole cluster needs to be shut down, which makes
it unavailable with 100 % chance.

If there's a .00001 % chance it *corrupts* the cluster, the function is
not acceptable. But iff it's a good chance to keep the cluster running,
it's worth having it (and should be used sensibly).

Regards,
Andreas


pgsql-patches by date:

Previous
From: "Dave Page"
Date:
Subject: Re: [HACKERS] Function to kill backend
Next
From: Peter Eisentraut
Date:
Subject: Re: pgxs: build infrastructure for extensions v4