Would an 8800GTS pair well with a Socket 939 CPU?

Currently I have an Athlon 64 3200+, but I'm thinking about upgrading to a Opteron 170. As for a GPU I have a Geforce 7600GS, and I've taken an interest in the 8800GTS 320mb.

If I do get the Opteron, will it pair well with an 8800? Meaning will I get the full power of the GPU without the CPU bottlenecking it? Or would it be better to wait until I get a whole new system (Core 2 system), and perhaps even get an 8900?

I have 1gb of RAM if that influences the decision, and I'm reluctant to upgrade since DDR1 RAM is a lot pricier than DDR2.