Re: Deadlock possibility in _bt_check_unique?
От
Tom Lane
Тема
Re: Deadlock possibility in _bt_check_unique?
Дата
Msg-id
4293.1269369637@sss.pgh.pa.us
Ответ на
Re: Deadlock possibility in _bt_check_unique? (Gokulakannan Somasundaram)
Список
Дерево обсуждения
Deadlock possibility in _bt_check_unique? Gokulakannan Somasundaram <gokul007@gmail.com>
Re: Deadlock possibility in _bt_check_unique? Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Deadlock possibility in _bt_check_unique? Gokulakannan Somasundaram <gokul007@gmail.com>
Re: Deadlock possibility in _bt_check_unique? Tom Lane <tgl@sss.pgh.pa.us>
Re: Deadlock possibility in _bt_check_unique? Gokulakannan Somasundaram <gokul007@gmail.com>
Re: Deadlock possibility in _bt_check_unique? Tom Lane <tgl@sss.pgh.pa.us>
Re: Deadlock possibility in _bt_check_unique? Gokulakannan Somasundaram <gokul007@gmail.com>
Re: Deadlock possibility in _bt_check_unique? Tom Lane <tgl@sss.pgh.pa.us>
Re: Deadlock possibility in _bt_check_unique? Gokulakannan Somasundaram <gokul007@gmail.com>
Re: Deadlock possibility in _bt_check_unique? Tom Lane <tgl@sss.pgh.pa.us>
Re: Deadlock possibility in _bt_check_unique? Gokulakannan Somasundaram <gokul007@gmail.com>
Gokulakannan Somasundaram 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 по дате отправления
От: Alvaro Herrera
Дата: