here is an interesting thread, obviously not very scientific because many conditions are unknown, but the data does illustrate some good point.this is for a PC. dont know if that matters but i would be interested to see what the stats are for os x.
AFAIK, firefox on mac manages memory about the same as its pc version, top at 120-150MB most of the time with time goes by. (heavy load flash webpages are different topic)