Re: How fair is SELECT FOR UPDATE ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
Cc: Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: How fair is SELECT FOR UPDATE ?
Date: 2005-10-19 18:28:00
Message-ID: 25083.1129746480@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Csaba Nagy <nagy(at)ecircle-ag(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rafael Montoya 2005-10-19 18:28:39 Re: From oracle to postgresql...
Previous Message Cristian Prieto 2005-10-19 18:24:45 SQL return value...