←back to thread

Postgres LISTEN/NOTIFY does not scale

(www.recall.ai)
570 points davidgu | 1 comments | 07 Jul 25 14:05 UTC | HN request time: 0.257s | source
Show context
hombre_fatal ◴[10 Jul 25 20:24 UTC] No.44525152[source]▶
Interesting. What if you just execute `NOTIFY` in its own connection outside of / after the transaction?
replies(4): >>44525332 #>>44525408 #>>44526003 #>>44528534 #
1. zerd ◴[11 Jul 25 04:57 UTC] No.44528534[source]▶
That would make the locked time shorter, but it would still contend on the global lock, right?