3 ms·
I'll add comments to this thread with Github projects that I can find by searching for "postgres listen/notify" on Github. https://github.com/graphile/worker h
by JoelJacobson 1y ago
I'll add comments to this thread with Github projects that I can find by searching for "postgres listen/notify" on Github.
https://github.com/graphile/worker https://github.com/graphile/worker
// Line 535 in src/main.ts
client.query('LISTEN "jobs:insert"; LISTEN "worker:migrate";')
Every worker pool seems to listen on the same shared channels:
jobs:insert - all workers get notified when new jobs are added
worker:migrate - all workers get notified about database migrations
- BenjieGillam 1y agoYep; we have a dedicated listener client per pool (and normally something like 1-20 pools, each with 1-100 workers); the workers themselves don’t listen. We also notify on every job or batch job insert, though we would love to rate limit this so we notify at most once per 2 milliseconds.