Bridge is a memory hog - no kidding! I just leave it open the entire time I'm on Photoshop.
CS3 should run just fine on your computer - one thing to note is that the print engine is still buggy - this is a common complaint for users, so keep CS2 handy for printing for now until they fix it.

Good luck - hope this helps-
-Lew ;-)