Y
Hacker News
new
|
ask
|
show
|
jobs
by
grk
1577 days ago
The problem with postgres-backed queues is they can't be used with connection pooling, so your workers are unnecessarily using up DB connections.
1 comments
waffle_maniac
1577 days ago
I thought that was an ActiveRecord problem. We use MYSQL and have a lot of long-lived connections.
link
grk
1577 days ago
Not sure how it works with MySQL, but with postgres the most common pooling options use transactional mode, which doesn't support LISTEN/NOTIFY.
link