6 ms·
The problem with postgres-backed queues is they can't be used with connection pooling, so your workers are unnecessarily using up DB connections.
by grk 5y 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.
- waffle_maniac 5y agoI thought that was an ActiveRecord problem. We use MYSQL and have a lot of long-lived connections.
- grk 5y agoNot sure how it works with MySQL, but with postgres the most common pooling options use transactional mode, which doesn't support LISTEN/NOTIFY.