Andrew - Supernews wrote:
Anyone have any ideas on how to handle a work queue?Advisory locks (userlocks in pre-8.2).
Can someone explain why these are a better fit than whatever locks SELECT FOR UPDATE acquires?
Thanks.
- John D. Burger
MITRE
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
