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