hard20 pts · first answer countstransactionsrow-lockspostgresql
Locked rows come back out of order
In PostgreSQL Read Committed, a worker runs the query below. Another session had locked one of the rows, raised its priority value, and then committed. What can the worker see?
SELECT * FROM jobs WHERE status = 'pending' ORDER BY priority DESC LIMIT 5 FOR UPDATE;
Discussion 0
Join free to post in the discussion.
Related questions
- Durability in ACIDDatabase Administrator
- Logical vs physical backupDatabase Administrator
- Why a write-ahead log existsDatabase Administrator
- Read-only access for analystsDatabase Administrator
- What pg_hba.conf controlsDatabase Administrator
- View vs materialized viewDatabase Administrator
- What ROLLBACK undoesDatabase Administrator
- Seeing what is running nowDatabase Administrator