Re: pg_listener entries deleted under heavy NOTIFY load only on Windows

Поиск
Список
Период
Сортировка
От Marshall, Steve
Тема Re: pg_listener entries deleted under heavy NOTIFY load only on Windows
Дата
Msg-id 4975D967.1070805@wsi.com
обсуждение исходный текст
Ответ на Re: pg_listener entries deleted under heavy NOTIFY load only on Windows  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-bugs
Marshall, Steve wrote:


    Any thoughts on how to confirm or deny Theory A?


  Alvaro Herrera wrote:
Try changing the 1000 to NMPWAIT_WAIT_FOREVER


I'd tried Alvaro suggestion and it fixed the problem in my test case. 
With the original code, the test would consistantly drop one of the
events from pg_listener within a few seconds.  With the changed
timeout, I've run it for about 10 minutes, or 100,000 notifications of
each event, and it worked without error.

Are there any side effects from effectively disabling this timeout that
should be tested?

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: BUG #4621: Password is shown on the terminal
Следующее
От: Oleg Serov
Дата:
Сообщение: Re: Bug in PL/PgSQL "SELECT .. INTO" statement parser