3 ms·
This is cool, but also, why is pg_notify designed with such a contentious queue?
by morshu9001 11mo ago
This is cool, but also, why is pg_notify designed with such a contentious queue?
- JoelJacobson 11mo agoIt's a common misconception that the single queue is a poor design choice. The user reports, of seeing notifications/second severely degrade with lots of backends, cannot be explained by the single-queue design. An efficient implementation of a single-queue, should flatten out as parallellism increases, not degrade and go towards zero.