It depends on the PSU. Some don't turn the fan on until the temperature or load gets beyond a certain point, but these tend to be the better brands. A Google will point you in the right direction. A PSU isn't as central to airflow as it once was, as this should be the remit of case fans - a lot of newer cases tend to have the PSU mounted in the bottom, with the intake on the bottom of the case.