Re: Deadlock possibility in _bt_check_unique?

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: Deadlock possibility in _bt_check_unique?
Дата
Msg-id
4293.1269369637@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
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 по дате отправления
От: Gurjeet Singh
Дата:
Сообщение: Re: Repeating Append operation
От: Alvaro Herrera
Дата:
FAQ