zlacker

>>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.)

>>pauldd+f9
Not all use cases are high throughput. That’s not what makes it a toy

>>klysm+9l
"Toy/low throughput" = "Toy or low throughout"

>>pauldd+hm
Can you define "low throughput"? I think people have significantly different ideas of what that means.

>>djur+TO
> Can you define "low throughput"?

IDK maybe <1000 messages per minute

Not saying SKIP LOCKED can't work with that many. But you'll probably want to do something with lower overhead.

FWIW, Que uses advisory locks [1]

[1] https://github.com/que-rb/que