Unlocking the Postgres Lock Manager with Bruce Momjian

Locking is critical for providing high concurrency for any database — you cannot fully utilize your hardware if locking is throttling its use. This talk explores all aspects of locking in Postgres by showing queries and their locks; covered lock types include row, table, shared, exclusive, and advisory lock types. The high concurrency provided by Multiversion Concurrency Control (MVCC) is also covered.

 

Bruce Momjian is a Postgres Core Team member and is one of the founders of the Postgres Development group. He is a senior Database Architect @ EnterpriseDB.



Join or login to comment.

  • Mark S.

    excellent information - also got to connect with Tom and several other postgres users

    January 20, 2012

10 went

Our Sponsors

  • DockYard

    Venue, Pizza, Soda, Video recording

People in this
Meetup are also in:

Create your own Meetup Group

Get started Learn more
Katie

I'm surprised by the level of growth I've seen since becoming an organizer, it's given me more confidence in my abilities.

Katie, started NYC ICO

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy