Learn more about postgres locks and how they can stall an entire database when put under too much load.