Postgres Pro
Downloads
Home   >   mailing lists

Re: Deadlock possibility in _bt_check_unique? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Deadlock possibility in _bt_check_unique?
Date
Msg-id 4293.1269369637@sss.pgh.pa.us
Whole thread Raw
In response to Re: Deadlock possibility in _bt_check_unique?  (Gokulakannan Somasundaram <gokul007@gmail.com>)
Responses Re: Deadlock possibility in _bt_check_unique?
List pgsql-hackers
Tree view 
Gokulakannan Somasundaram <gokul007@gmail.com> writes:
> Consider Time instances T1, T2, T3, T4

> T1 : session 1 holds the write lock on page p1 and completes the unique
> check on p1, p2 and p3.

> T2 : session 1 releases the lock on p1 (its waiting to acquire a ex lock on
> p2)

That's not what we do.  See _bt_findinsertloc.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Gurjeet Singh
Date:
Subject: Re: Repeating Append operation
Next
From: Alvaro Herrera
Date:
Subject: Re: Proposal: access control jails (and introduction as aspiring GSoC student)