←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.256s | source
Show context
sleepy_keita ◴[11 Jul 25 01:04 UTC] No.44527431[source]▶
LISTEN/NOTIFY was always a bit of a puzzler for me. Using it means you can't use things like pgbouncer/pgpool and there are so many other ways to do this, polling included. I guess it could be handy for an application where you know it won't scale and you just want a simple, one-dependency database.
replies(3): >>44527549 #>>44528158 #>>44528472 #
1. valenterry ◴[11 Jul 25 03:31 UTC] No.44528158[source]▶
How about using a service that runs continuously and brings it's own pool? So basically all Java/JVM based solutions that use something like HiKariCP.