Foreign keys locking

Поиск
Список
Период
Сортировка
От James Pharaoh
Тема Foreign keys locking
Дата
Msg-id 1091453230.20919.27.camel@localhost.localdomain
обсуждение исходный текст
Список pgsql-hackers
Hi,

I am using postgresql for a system, and having a lot of deadlocks due to
foreign keys. I am aware of the situation regarding this from browsing
the mailing list archives.

As I understand it the solution is to implement dirty reads and modify
the referential integrity triggers to use these instead of for update
locks.

How much work is involved in getting this done? Is interested in getting
paid to undertake this?

Please contact my email directly as I am not subscribed to this list.

James Pharaoh




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Fwd: init scripts and su
Следующее
От: "Hicham G. Elmongui"
Дата:
Сообщение: error in linking