Re: Connecting to NOTIFY with telnet

Поиск
Список
Период
Сортировка
От Igal Sapir
Тема Re: Connecting to NOTIFY with telnet
Дата
Msg-id CA+zig08+Xw5SdHzMwjf+=DEPVadWkPq0aPT_uNdQ8ZNK+vOXqg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Connecting to NOTIFY with telnet  (Christoph Moench-Tegeder <cmt@burggraben.net>)
Ответы Re: Connecting to NOTIFY with telnet  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-general
Christoph,

On Sat, May 4, 2019 at 10:44 AM Christoph Moench-Tegeder <cmt@burggraben.net> wrote:
## Igal Sapir (igal@lucee.org):

> My main "issue" is that the official pgjdbc driver does not support the
> notifications with listen and I was trying to figure out why.

https://jdbc.postgresql.org/documentation/head/listennotify.html


I should have been more explicit.  My main issue is with the following statement from the link that you posted:

> A key limitation of the JDBC driver is that it cannot receive asynchronous notifications and must poll the backend to check if any notifications were issued

Polling is much less efficient than event handling and I'm sure that there's a major performance hit with that.

Thanks,

Igal
 

В списке pgsql-general по дате отправления:

Предыдущее
От: Christoph Moench-Tegeder
Дата:
Сообщение: Re: Connecting to NOTIFY with telnet
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: Connecting to NOTIFY with telnet