Hacker News Reader

SELECT FOR UPDATE means two queries can’t _read_ the same row at the same time, right?

To my understanding, yes. If you have broad select queries across all the rows, that would slow things down quite a bit.

You can use SKIP LOCKED normally. That’s how popular queue implementations usually work. I believe pg even calls this out in their docs