←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.438s | source
Show context
polote ◴[10 Jul 25 20:38 UTC] No.44525307[source]▶
Rls and triggers dont scale either
replies(2): >>44525677 #>>44525805 #
shivasaxena ◴[10 Jul 25 21:12 UTC] No.44525677[source]▶
Yeah, I'm going to remove triggers in next deploy of a POS system since they are adding 10-50ms to each insert.

Becomes a problem if you are inserting 40 items to order_items table.

replies(5): >>44525741 #>>44526565 #>>44526644 #>>44526757 #>>44526964 #
1. brikym ◴[10 Jul 25 22:48 UTC] No.44526565[source]▶
Have you tried deferring them?