Comment by padjo

You can go an awfully long way with just SELECT … FOR UPDATE … SKIP LOCKED