3 ms·
>Our system handles hundreds of worker nodes constantly polling our PostgreSQL-backed control plane for new jobs Does everybody poll their PosgreSQL to get new
by gloosx 2y ago
>Our system handles hundreds of worker nodes constantly polling our PostgreSQL-backed control plane for new jobs
Does everybody poll their PosgreSQL to get new rows in real-time? This is really weird, there are trigger functions and notifications.
- lunarcave 2y agoIn pg, each unique `listen(channel)` takes up server resources, and if you don't reliably clean them up, everything comes to a screeching halt. There's also `max_notify_queue_pages` >Specifies the maximum amount of allocated pages for NOTIFY / LISTEN queue. The default value is 1048576.