Re: Listen / Notify - what to do when the queue is full
Andrew Chernow <ac@esilo.com>
From: Andrew Chernow <ac@esilo.com>
To: Greg Stark <gsstark@mit.edu>
Cc: Greg Sabino Mullane <greg@turnstep.com>, pgsql-hackers@postgresql.org
Date: 2009-11-19T01:26:18Z
Lists: pgsql-hackers
> > That is, if the queue overflows what you should do is drop the > payloads and condense all the messages for a given class into a single > notification for that class with "unknown payload". That way if a > cache which wants to invalidate specific objects gets a queue overflow > condition then at least it knows it should rescan the original data > and rebuild the cache and not just serve invalid data. > That's far more complicated than throwing an error and it discards user payload information. Let the error indicate a rescan is needed. -- Andrew Chernow eSilo, LLC every bit counts http://www.esilo.com/