avast is relatively light on resources in comparison to other AV (see image). However, if you are having to worry about memory usage, you probably don't have much of it and increasing your RAM will greatly improve overall system performance. In use the memory requirements will change as it scans files, web pages, emails, etc. so it can fluctuate, but that is true with other AVs.
What is your system specification ?