Fixing foreign key deadlocks, part three
Posted Tuesday Aug 9th, 2011 09:00am
by Alvaro Herrera | Permalink

As I have posted in previous articles ( Fixing foreign key deadlocks and Part 2), I am working on reducing the lock strength required by foreign key checks. I have a working patch that solves a lot of the problems already; however it doesn't solve the one problem that I initially set to fix. It turned out to require a bit more rejiggering than I initially considered.

Note: this article assumes that you know what I have already done in the patch I posted. If you want to follow through, I suggest you read the first two links above as an introduction.

Read more...

---

blog comments powered by Disqus