Hacker News .hnnew | past | comments | ask | show | jobs | submitlogin

I'd be doing the same in the case of the post; it's guarneteed to hit locks some percentage of time. Should be better than a single slot though.

The whole point of the article was that idle-in-transaction due to locks on a counter in another transaction cause bottlenecks; skipping them using SKIPLOCKED with enough slots eliminates this. Randomly selecting them also randomly picks the locked one, causing a wait.



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

Search: