The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/sql-notify.html Description:
The authors of the following article got stuck and had to read postgres' source code to realize that NOTIFY takes a global instance lock: https://www.recall.ai/blog/postgres-listen-notify-does-not-scale https://news.ycombinator.com/item?id=44490510 It may be useful to mention that in https://www.postgresql.org/docs/current/sql-notify.html