Maximum Number Notifications - Mailing list pgsql-general

From Dawn Hollingsworth
Subject Maximum Number Notifications
Date
Msg-id 1084382892.11909.3.camel@kaos
Whole thread Raw
Responses Re: Maximum Number Notifications  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general

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.



pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Washintonians and Oregonians
Next
From: MaRCeLO PeReiRA
Date:
Subject: Profiling PostgreSQL