Originally posted by madhurvyas 150dpi is good for most purpose of viewing from 1/2meter and far, below that you should use higher dpi, but normally we see large printed posters form a meters distance.
IT was said from close distance too
As to if you see from close distance or not really depend of use case.
When I see an 1.5x2.5m (or something) poster on a bus stop from my car I don't really notice the large pixels. But if I'am the guy at the bus stop (I have been many time) I can really see the ugly huge pixels because I naturally seat near the poster. This for sure doesn't improve the impression I get from the poster.
If there is some ad somewhere that is poster it is very likely I will never want if I have the choice to see it from close distance to better see it. If I go to a gallery looking to photos, I might want to see the photo that interrested me the most to close distance. If something is interresting you take more time looking at it, you discover it from several distance.
If the painting, the photo is not meant to be shown from close distance, that may not be bad at all ... BUT it will not give the nice impression you'd get from a painting/photo with lot of small interresting details you only see from close.
So if I decide to finally buy the photo in large size and put it in a big wall of my house, I'd appreciate that when I look close to it I might see lot of small interresting details. Like if I have a big city landscape overall I can see the human in detail when I close to it and see maybe one guy buying something to a marchant here or maybe see the detail of some window reflection. That's really fun and interresting.
That may not be the purpose of one photo and that's not necessary, but in some case this is really interresting. And from another thread I think for the photos that sell for the highest money, there were incredibly sharp and detailled (scan of big film) and printed in huge size... Apprently I'am not alone in the trip ! Even through I have not the money to buy such huge prints anyway !