Csaba Nagy <nagy@xxxxxxxxxxxxxx> writes: > I wonder how fair is the lock allocation of SELECT FOR UPDATE ? > Is it fair, i.e. the first transaction which requested the lock will get > it, or it is possible that new requests are served quicker ? 8.1 will guarantee first-come-first-served for row-level locks, but prior releases make no guarantees. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly