During concurrent transactions that involve select and update commands, pseudo-column-level locking can allow some queries to return values from locked rows, and can allow other queries to avoid blocking on locked rows that do not qualify. Pseudo-column-level locking can reduce blocking when:
The select query does not reference columns on which there is an uncommitted update.
The where clause of a select query references one or more columns affected by an uncommitted update, but the row does not qualify due to conditions in other clauses.
Neither the old nor the new value of the updated column qualifies, and an index containing the updated column is being used.
