Re: [HACKERS] Query cancellation and OOB

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [HACKERS] Query cancellation and OOB
Дата
Msg-id 199805190516.BAA07857@candle.pha.pa.us
обсуждение исходный текст
Ответ на Query cancellation and OOB  (Brandon Ibach <bibach@infomansol.com>)
Ответы Re: [HACKERS] Query cancellation and OOB  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Vadim Mikheev
Дата:
Сообщение: hi!
Следующее
От: "Maurice Gittens"
Дата:
Сообщение: Re: [HACKERS] Query cancel and OOB data