Y
Hacker News
new
|
ask
|
show
|
jobs
by
mamcx
8 days ago
Is the optimization only possible using dbos? is not clear to me if this mean a way to tune normal PG
1 comments
KraftyOne
8 days ago
The core optimization is to buffer notifications in-memory and send them in a batch instead of sending them as part of every transaction. So that's a general-purpose optimization for Postgres apps using LISTEN/NOTIFY.
link
mamcx
8 days ago
So this is not inside a trigger but on the app connected to pg?
link
gordonhart
8 days ago
Yes, per the article they “scaled” Postgres to meet their requirements by altering their usage pattern to avoid hitting the bottleneck.
link