Darren Govoni <darren@xxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general