the docs for NOTIFY do not mention the global lock that NOTIFY takes
Started by PG Bug reporting form10 months ago1 messagesdocs
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