Re: elegant and effective way for running jobs inside a database

Alvaro Herrera <alvherre@commandprompt.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