zlacker

[parent] [thread] 0 comments
1. maniga+(OP)[view] [source] 2019-05-28 00:06:42
Delaying the commit is the standard approach with this. SKIP LOCKED was created specifically to avoid the throughput issues of locked rows (and has similar implementations in other RDBMS).

If you don't want to keep the transaction open than you can just go back to updating a column containing the message status, which avoids keeping a transaction open but might need a background process to check for stalled out consumers.

[go to top]