Depends on your AP. Some don't support powersaving mode very well, and will cause your n900 to eat so much power it gets warm and lasts 4 hours or less.

With a non-buggy AP though, the n900 will idle for days with wifi active (assuming nothing else consuming excessive power, of course).