Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> I was thinking that the connection would be kept open but no query would
> be running. Does this preclude reception of notifies? I mean, you
> don't sleep via "SELECT pg_sleep()" but rather a select/poll in the
> daemon.
No. If you're not inside a transaction, notifies will be sent
immediately. They'd be pretty useless if they didn't work that way ---
the whole point is for clients not to have to busy-wait.
regards, tom lane