I recommend AVG anti-virus, they have a free edition which is really good. It has low system resource usage, live scanning (like it will tell you if you have downloaded a zip file that contains a virus), email scanning... And it automatically checks for updates every day, which they release a new virus database every 2-3 days.
http://www.grisoft.com/ if anyone is interested.