Re: [HACKERS] Not your father's question about deadlocks

From: "Gurjeet Singh" <singh(dot)gurjeet(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Clarence Gardner" <clarence(at)silcom(dot)com>, pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org, "Alvaro Herrera" <alvherre(at)alvh(dot)no-ip(dot)org>
Subject: Re: [HACKERS] Not your father's question about deadlocks
Date: 2006-11-16 21:07:35
Message-ID: 65937bea0611161307s27bb6855k107469a4c6760754@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On 11/17/06, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> "Gurjeet Singh" <singh(dot)gurjeet(at)gmail(dot)com> writes:
> > Small implementation detail: Also keep a count of how many times the
> same
> > session requested the same lock, and do not release the lock until he
> > requests same number of releases.
>
> No need for that, because there isn't any heap_unlock_tuple.
>

Cool... I didn't know we could get away with that in PG land!!

I assume unlocking is done by a COMMIT/ROLLBACK.

--
gurjeet[(dot)singh](at)EnterpriseDB(dot)com
singh(dot)gurjeet(at){ gmail | hotmail | yahoo }.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-11-16 21:08:02 Re: How to crash postgres using savepoints
Previous Message One 2006-11-16 21:03:20 Extract between year *and* month

Browse pgsql-hackers by date

  From Date Subject
Next Message Dwight Emmons 2006-11-16 21:47:01 Cast null to int4 upgrading from Version 7.2
Previous Message Tom Lane 2006-11-16 21:01:58 Re: [HACKERS] Not your father's question about deadlocks