I think the code is somehow interrupt based, but I don't know. I've
asked the primary maintainer of the program to look into this with me.
We should have more insight by early next week.
Peter
Tom Lane wrote:
> "Peter Koczan" <pjkoczan(at)gmail(dot)com> writes:
>
>> This app uses Perl/DBD::Pg, and the code is basically:
>>
>
>
>> while ($dbh->func('pg_notifies')) {
>> # do stuff
>> }
>>
>
> If I'm not mistaken, that loop would process all the currently available
> notify messages and then fall out. So the real question is what's
> around this --- what conditions will make the program come back to this
> loop periodically? Or not do so?
>