When does a fan not become enough during summer?

What heat index or temperature roughly is too much to bear even with cracked windows, minimal clothes, sleeping on top on minimally insulated material and fan for sleeping?

Also when does it become uncomfortable for sleeping?