Memory sucks up very little power so you most likely wont need to upgrade your power supply. If were talking upgrading your video card or CPU which suck take the most power then yes it does matter and it depends on the particular video card and CPU some GPU's and CPU's take more power then others.
What are you currently running?