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
SELECT the oldest row without locking
B
Each worker scans the whole table and picks randomly
C
SELECT ... FOR UPDATE SKIP LOCKED to claim rows without workers blocking on each other
D
Use a sequence and LIMIT 1 without a transaction