Our company is currently utilizing PostgreSQL 7.2.3 for one of our
product lines.
We seem to be having issues lately where the applications are not always
receiving database notifications. I have been looking through the code
and I think the problem may stem around a stored procedure that has a
NOTIFY in it that can possible be triggered hundreds of times in a given
minute.
We are currently fixing this problem but my question is how many NOTIFYs
can be stored in postgres if the client who is listening is not polling
the database?
Dawn Hollingsworth
Senior Director Research & Development
AirDefense, Inc.