On Apr 8, 2005, at 10:59 AM, Andrew Sullivan wrote:
> wakes up the mail-sender client with the NOTIFY; the NOTIFY and the
> commit to the mail-it table only happen in that case if the
> transaction commits. And since mail is async anyway, the extra few
> seconds shouldn't make any difference, right?
>
I have a lot of processing that could benefit from this type of
synchronization, except the fact that there's no Pg command to "wait
until I get a notify message". You have to constantly poll to see if
you got one, which negates a lot of the benefit of async notification
to rarely run processes.
Vivek Khera, Ph.D.
+1-301-869-4449 x806