> if code is written to handle 1 job at a time and needs to make several roundtr... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		dns_snek 34 days ago \| parent \| context \| favorite \| on: I’m leaving Redis for SolidQueue > if code is written to handle 1 job at a time and needs to make several roundtrips to the same db inside the same locking transaction. Do you mean the application code? The worker itself causing the bottleneck is definitely one possibility however if that were the case the issue wouldn't have resolved itself when they switched to a different job queue.

vjerancrnjak 34 days ago [–]

Well, you would no longer have thousands of open transactions maintaining the locks.

Of course, if q on top of psql is reasonably implemented (lease), what they say makes no sense.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact