zlacker

[return to "Choose Postgres queue technology"]
◧
1. pauldd+f9[view] [source] 2023-09-24 21:33:30
>>bo0tzz+(OP)
USE. ADVISORY. LOCKS.

Do not use SKIP LOCKED unless it is a toy/low throughout.

Row locks require transactions and disk writes.

Advisory locks require neither. (However, you do have to stay inside the configurable memory budget.)

◧◩
2. ukd1+Sc[view] [source] 2023-09-24 22:08:04
>>pauldd+f9
Maybe it's changed in the last year or so, but from benchmarking and writing / running queue software for Postgres - SKIP LOCKED was/is significantly faster. Is that different for MySQL?
[go to top]