the docs for NOTIFY do not mention the global lock that NOTIFY takes

Поиск
Список
Период
Сортировка
От PG Doc comments form
Тема the docs for NOTIFY do not mention the global lock that NOTIFY takes
Дата
Msg-id 175222328116.3157497.2260121997954044239@wrigleys.postgresql.org
обсуждение исходный текст
Список pgsql-docs
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

В списке pgsql-docs по дате отправления: