PDXPUG: February 16, 2012

High-traffic systems have to deal with locks. That's just the way it
is. But that's okay! Locks invisibly help manage concurrency! Properly
structured transactions will never run into deadlocks with each other!
Right?

Well, sometimes locks are very visible, and sometimes you end up with
deadlocks that don't make sense. I'm going to talk through a couple of
row-locking problems i've run into, and explain how and why that
should end up changing PostgreSQL's SQL syntax.

John's been poking computers since he was old enough to type, which
was long enough ago that he debated whether to make a "POKEing" joke.
He's a Software Engineer at Janrain, working with the reporting and
analytics infrastructure.

Loading more stuff…

Hmm…it looks like things are taking a while to load. Try again?

Loading videos…