←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.4s | 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 #
parthdesai ◴[10 Jul 25 21:48 UTC] No.44526003[source]▶
You lose transactional guarantees if you notify outside of the transaction though
replies(2): >>44526146 #>>44534706 #
1. gwbas1c ◴[11 Jul 25 17:15 UTC] No.44534706[source]▶
... And working outside of the guarantee is harder, especially if you're in a "move fast and break things because we can fix it later" mode.

Anyway, the article indicates that the fix was very simple and primarily in the application layer. Makes me wonder if someone was getting "creative" when they used LISTEN/NOTIFY.