Very relevant (and highly recommended) read: https://www.2ndquadrant.com/en/blog/what-is-select-skip-lock...