Remember that CS2 is not universal and running it through Rosetta will take more RAM. I would say at least 1.5GB. CS2 is a RAM hog anyway and Rosetta just makes that worse.
I have 2GB on my G5 iMac and use CS. Sometimes that feels like it is not enough.