It seems that my PS3 only shows the yellow light if I turned the PS3 on for the first time during the day. So, overheating can be ruled out. I let the PS3 on overnight when downloading a huge patch for Burnout Paradise, and it survived.
Also, when playing LA Noire, the fan only go loud after...