←back to thread

Postgres LISTEN/NOTIFY does not scale

(www.recall.ai)
570 points davidgu | 2 comments | 07 Jul 25 14:05 UTC | HN request time: 1.34s | 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. soursoup ◴[10 Jul 25 20:40 UTC] No.44525332[source]▶
Isn’t it standard practice to have a separate TCP stream for NOTIFY or am I mistaken
replies(1): >>44525529 #
2. remram ◴[10 Jul 25 20:57 UTC] No.44525529[source]▶
You mean for LISTEN?