It really is the memory, or lack of
Avast scans executables when opened, well, this is a LOT more than one thinks, windows will have a couple hundred or more executables open at any time.
Ok, for your cpu spikes, ( i have dual monitors and can watch it) is caused by your lack of RAM, whenever you open or close things, it will scan, this is just a blip on mine, but! if you don't have the ram then it has to swap, which takes lots lots longer.
Hope it was some sort of help, oh btw, on my game system, which has avast diasbled and doesn't run Anything other that what is necessary Ram usage is 192 megs. and that is really really low, this system, (used for the net and downloading) uses 384megs ...at idle :p
Oh, more on this, on web pages, it's scanning .js files, java scripts, which are potentially very very bad.