3 ms·
In one of my projects I was going to use something like that: "update ... skip locked" was used in isolated short transaction, which would just update that job
by codesnik 9y ago
In one of my projects I was going to use something like that: "update ... skip locked" was used in isolated short transaction, which would just update that job with "taken" flag and timestamp and commit that. "stuck jobs" worker was meant to fire as rare as possible for cases of unhandled failures, but was still there.