Re: signal handling in plpython - Mailing list pgsql-hackers

From Tom Lane
Subject Re: signal handling in plpython
Date
Msg-id 12585.1476467435@sss.pgh.pa.us
Whole thread Raw
In response to Re: signal handling in plpython  (Heikki Linnakangas <hlinnaka@iki.fi>)
Responses Re: signal handling in plpython  (Andres Freund <andres@anarazel.de>)
Re: signal handling in plpython  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Heikki Linnakangas <hlinnaka@iki.fi> writes:
> On 14 October 2016 16:22:12 EEST, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> I don't know whether to laugh or cry, but that code is a joke.  Just
>> silently fail if you can't get the lock?

> Heh, ok, let me rephrase: I believe it's *intended* to be callable from a signal handler :). Whether it actually
worksis another question. Perhaps there's some mitigating conditions there, I don't know. 

> For our use case, it's actually not too bad if Py_AddPendingCall gives up and does nothing. Then the python function
willsimply not be interrupted until next SPI call, which is the current situation anyway. 

I dunno.  If the failure were very low-probability, you could maybe live
with that behavior, but I'm not sure it is.  Presumably the Python
interpreter loop is taking that lock once per statement (at least), so
that it can tell if there's something to do.  That'd suggest that the
fraction of time in which the lock is held is not negligible.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: tablesample test failure with small TOAST_TUPLE_THRESHOLD
Next
From: Andres Freund
Date:
Subject: Re: signal handling in plpython