I have just upgraded from XP to Windows 7 and would like to run CS4 on this new system.
As far as i can tell it works fine on windows 7.
It worked for me on Windows 7 (64 bit) before I upgraded it. I had no problems with it.
Good move, avoiding Windows 8. I don't think it's mature enough even now.