It depends. For regular use, 4Gb should be perfectly adequate. For image manipulation, some high-end games, the more the better.
In general if you have experience with Vista, you will find Win7 better, faster and more efficient than Vista on the same hardware.