Re: [HACKERS] Query cancellation and OOB - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] Query cancellation and OOB
Date
Msg-id 199805190516.BAA07857@candle.pha.pa.us
Whole thread Raw
In response to Query cancellation and OOB  (Brandon Ibach <bibach@infomansol.com>)
Responses Re: [HACKERS] Query cancellation and OOB
List pgsql-hackers
>
>    It just occurred to me, while browsing through the last hacker's
> digest, that OOB might be more trouble than it's worth.  What about
> having the Postmaster listen on a second socket as an alternative?
> Certain commands could be issued there, outside of the main connection
> (possibly even via UDP) as one-shot deals (not requiring a persistent
> connection) and the postmaster could pass the information on to the
> appropriate backend in a nice, intrusive fashion. :)

Yes, but you have to make sure the cancel is ONLY coming from the proper
client.  The signal thing is nice, so how do you simulate that, unless
you have the postmaster send the signal to the proper child?

I hate to add lots of stuff just to get CANCEL to work on unix domain
sockets.

--
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

pgsql-hackers by date:

Previous
From: Vadim Mikheev
Date:
Subject: hi!
Next
From: "Maurice Gittens"
Date:
Subject: Re: [HACKERS] Query cancel and OOB data