The only time I've rendered to avi is when I'm doing a quick seconds per frame video, and I usually don't render more than about 300 frames at a time. If I'm doing anything more render intensive, I definitely use tif or png.