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. klysm+9l[view] [source] 2023-09-24 23:30:29
>>pauldd+f9
Not all use cases are high throughput. That’s not what makes it a toy
◧◩◪
3. pauldd+hm[view] [source] 2023-09-24 23:43:12
>>klysm+9l
"Toy/low throughput" = "Toy or low throughout"
[go to top]