(Now, disabling that idiotic SuperFetch service, OTOH, is well worth it, especially if you have a SSD, but even if you are still using a HDD. Because in the absence of SF, the system seems much more willing to keep old data--like say a large file you copied a while back--resident until it absolutely doesn't need it any more.)
SuperFetch has little to do with
keeping stuff in RAM, that would be the regular "reactive" Windows file cache, which you can't disable (as a user/admin, that is; programmers can bypass it, that's an option when you open a file).
SuperFetch was really overly aggressive in Vista. One afternoon I installed Adobe Acrobat. 9Full Acrobat, not just Reader.) For several days after I'd notice that my disk LED would start flickering at about that same time each afternoon (it does track usage times and times its prefetching based on when you last asked for the file!). this was on a laptop, and the hit on the hard drive was noticeable. Resource Monitor showed that it was the Superfetch service, reading the installer file! Hm, no, that really wasn't helpful. I thwarted that by renaming the file.
It got a lot more cautious in Win 7, and Windows disables it by default for SSDs. So that's another tweak you don't have to do.
Still, the pages of RAM that SuperFetch uses aren't really "used". It does not increase memory pressure one iota. The pages it uses start on the standby page list (part of the "available" counter in Task Manager), and after SuperFetch uses them
they are still on the standby list and are just as available for use by any other process that needs them! It generally uses only the "low priority" portion of the Standby list, meaning stuff that was referenced a long time ago.