Bottleneck issues of course (major one), as you had asked in your question.
If you get the HD 6790 and put it in a Pentium D system, what will happen is that the card won't be at it's full potential. It will be only using about half of it's total performance that can be delivered. Your better off building another rig. The PSU and the RAM is okay.