There is a performance gain for having it on, being accessing some frequently used files (usually the essentials) from RAM rather then HDD. I would NOT recommend the turning off this feature as it WILL release all RAM held for frequently used files if needed, therefore it will not hog or halt the use of ram.
You can check this when you play a game, check the memory before and after.
My Windows 7 uses around 700 mbs when all programs are closed leaving only:
CCC, Avira, Windows updates, and my Logitech webcam software (under minimized).
Windows 7 uses around 800~ when using Chrome in resolution of 1920x1020 (screen is 1920x1080 but about 60 pixels are taken by taskbar).
Windows 7 Can use up to 1-1.1gbs of ram when running multiple chrome windows, Zune, and sometimes Powerpoint (Office Ultimate 2007)
OS: Windows 7 Professional 64 bit (programs use a bit more ram)
Superfetch: On
UAC: Off
Aero: On
Performance vs Quality for Aero: Quality
Default Features of Windows 7 are all on or off depending on default:
Antivirus: Avira Personal Antivirus
Firewall: On (Private/Public)
Adware/Spyware: Avira Personal Antivirus (Somewhat)
Ill give you the results of Windows 7 after disabling Superfetch. Brb
Ram: 785 mbs as the same setup as before, nothing but CCC Avira antivirus, windows updates, and logitech webcam.
Superfetch: Off
UAC: Off
Aero: On
Performance vs Quality for Aero: Quality
Default Features of Windows 7 are all on or off depending on default:
Antivirus: Avira Personal Antivirus
Firewall: On (Private/Public)
Adware/Spyware: Avira Personal Antivirus (Somewhat)
Ram with chrome open: 836
Seems that there is little difference which can be negated due to performance variables in the use of RAM. Best keep Superfetch On.