If CS3 is anything to go by, CS4 should run quite well even on a modest,
modern system.
CS3 runs very easily on my 2-year old PC, 32-bit XP and 1Gb RAM. By
contrast, PSE6 runs much slower and takes longer to start, so it seems
Adobe have worked harder on PS performance than they have on PSE. No
doubt that trend will continue.