←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.741s | source
Show context
dumbfounder ◴[10 Jul 25 21:35 UTC] No.44525875[source]▶
Transactional databases are not really the best tool for writing tons of (presumably) immutable records. Why are you using it for this? Why not Elastic?
replies(3): >>44525903 #>>44525945 #>>44550782 #
incoming1211 ◴[10 Jul 25 21:39 UTC] No.44525903[source]▶
Because transactional databases are perfectly fine for this type of thing when you have 0 to 100k users.
replies(2): >>44527793 #>>44560364 #
1. dumbfounder ◴[14 Jul 25 13:59 UTC] No.44560364[source]▶
The article is about scaling issues with tons of writes, which I referenced by saying “tons of writes”. Yes, if there is no reason to scale it up you can just use a database. But that’s not the context.