When: 7-9pm Thu Feb 16, 2012
Who: John Melesky
What: Locks… etc.
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.
Our meeting will be held at Iovation, on the 32nd floor of the US Bancorp Tower at 111 SW 5th (5th & Oak). It’s right on the Green & Yellow Max lines. Underground bike parking is available in the parking garage; outdoors all around the block in the usual spots. No bikes in the office, sorry!
Building security will close access to the floor at 7:30.
After-meeting beer location TBD. See you there!