Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
>
>>Sailesh Krishnamurthy wrote:
>>
>>>Does pgsql only record X locks on the individual tuples on-disk or
>>>does it do so for S locks as well ?
>
>
>>We don't need to shared lock individual rows because of MVCC --- well,
>>we sort of do by recording our xid in our proc structure, so folks don't
>>change things underneath us. We prevent expired rows from disappearing
>>from the disk by others looking at our proc start xid.
>
>
> This is actually an issue though. Row-level shared locks would be
> really nice to have for foreign-key handling. Right now we have to
> use X locks for those, and that leads to deadlocking problems for
> applications.
Yes! Yes! It's the last big hurdle for an otherwise excellent RI
implementation...
Just wanted "Joe-user's" enthusiasm for row-level S locks registered
somewhere... :-)
Mike Mascari
mascarm@mascari.com
