Practice
Learn
← Quit
0 / 0 correct
System Design
Hard
1 of 40
How can a Postgres table be used as a reliable job queue for many workers?
A
Use a sequence and LIMIT 1 without a transaction
B
SELECT ... FOR UPDATE SKIP LOCKED to claim rows without workers blocking on each other
C
SELECT the oldest row without locking
D
Each worker scans the whole table and picks randomly