Re: Can LISTEN/NOTIFY deal with more than 100 every second?

From: Yeb Havinga <yhavinga(at)gmail(dot)com>
To: Gavin Mu <gavin(dot)mu(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Can LISTEN/NOTIFY deal with more than 100 every second?
Date: 2010-02-01 12:17:25
Message-ID: 4B66C655.1000504@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Gavin Mu wrote:
> CREATE OR REPLACE RULE send_notify AS ON INSERT TO log DO ALSO NOTIFY logevent;
>
..
> when I use 3 similar programs to feed data, which means about 75
> events every second, I found that Postgres didn't send NOTIFY
> opportunely, since the client do SELECT query every several hundreds
> seconds, which is too long to be acceptable.
>
Hello Gavin,

The following might help from the notify docs:

"NOTIFY behaves like Unix signals in one important respect: if the same
notification name is signaled multiple times in quick succession,
recipients might get only one notification event for several executions
of NOTIFY."

So if your notify for instance could also add a unique number to the
notification name, then it will probably work as expected.

Regards,
Yeb Havinga

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message ray joseph 2010-02-01 12:21:55 Re: How to test my new install
Previous Message Raymond O'Donnell 2010-02-01 12:17:19 Re: How to test my new install