The problem with notify is it can miss notifications if the connection drops (e.g. you restart the application process, server, or database), and I think also i

The problem with notify is it can miss notifications if the connection drops (e.g. you restart the application process, server, or database), and I think also if there are too many notifications. It's only really useful for things that should happen, not for things that must happen.