Postgres Pro
Downloads
Home   >   mailing lists

Re: How fair is SELECT FOR UPDATE ? - Mailing list pgsql-general

From Tom Lane
Subject Re: How fair is SELECT FOR UPDATE ?
Date
Msg-id 25083.1129746480@sss.pgh.pa.us
Whole thread Raw
In response to How fair is SELECT FOR UPDATE ?  (Csaba Nagy <nagy@ecircle-ag.com>)
List pgsql-general
Tree view 
Csaba Nagy <nagy@ecircle-ag.com> 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

pgsql-general by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: [pgsql-advocacy] Oracle buys Innobase
Next
From: Mark Rae
Date:
Subject: Re: PostgreSQL on Dual Processors, Dual-Core AMD Chips