If you search "Avast" on google groups, use of resources is really the only critiicism people make of the product.
Norton Anti-Virus appears to use the most resources of all anti-virus products - and this is also the consistent criticism I found with Norton.
McAfee appears to fall somewhere in the middle, but as I said, I really don't notice its presence.
So if Avast is like Mcafee (or better), and I suspect it may well be based on the above responses, then Avast is for me.