Darren Govoni <darren(at)ontrenet(dot)com> writes:
> For example, there is a table with many rows. Threads are doing
> "SELECTS" to read some rows. They should be allowed to get results on
> rows that are not currently locked by another thread's SELECT,FOR UPDATE
> or equivalent read lock for those rows only.
Make those threads use SELECT FOR SHARE.
regards, tom lane