Character contractibility of Banach algebras and homological properties of Banach modules