PostgreSQL Locking Revealed
169 points by seaghost
Read the article
Discussion on Hacker News