My upstairs stays an unpleasent 102 degrees from about 2 pm till 9 pm when it begins to cool off to around 80. Any ideas on how to cool the upstairs? It's a cape cod style home so the ceiling is just the other side of the roof, no attic space between. Also no trees shade the roof so it bakes from sun up till sun down! I swear my wife could bake cookies of she just left a tray with batter on it up on the dresser for a day ideas!?
When I was growing up back East, we had a fan in the upstairs of the house which blew out, moving hot air that had risen to the upper floors out a window. It took care of things very simply and efficiently.
The exhaust fan the relache speaks about will be helpful if large enough and you have windows on a cool side of the house that you can open. The hot air will be blown out while the cooler air will be drawn in. You can not run such a fan without providing supply air from the open window(s).
In Ohio, I believe it is too humid to make use of inexpensive evaporative cooling. That leaves refrigerated air conditioning - expensive but it works.
Central air conditioning fails to work properly if there is inadequate exhaust air. You can't put cold air in if you can't take the hot air out. The ducting and venting and maybre the size of the fan and compressor need to be confirmed.
Central air, turned on after an exhaust fan has blown out the bulk of the overheated air will make a huge difference.
If you can nstall solar film on your windows, it greatly cuts the heat coming in through glass. I hadva house with west-facing windows in the master BR, and that saved our sanity.
Is there a way to paint your roof white? Or re-roof and install that thin (almost tinfoil-like shield between the roof deck and the shingles? That stuff works wonders. You can put it in attics, and even here in Texas, the attic will be 90 degrees when others are 140 or more. But you have no attic - the shield can, however, be put beneath the shingles if you re-roof at some point.
I have no clue as to how your house is designed. But, the way you mentioned the heating is because of the terrace. If it's a cemented terrace or something firm (not tiles) you could try throwing some water on the roof early in the mornings it would keep most of the heat out. Also, try installing a few mirrors on the roof (It would reflect most of the heat). Better still, if you can - use the enormous heat using some sort of solar device (up to you to decide what you need).