Samiad wrote:
If your only goal is to print 6x4's and view from 10" then there is no issue is there? The issue would only occur if you wanted to generate much large prints (and you might attempt to, with a 5000 megapixel sensor!).
Your last phrase is the most important, and your question is not simplistic at all. There are two phenomenon that limit the size of a print: The resolution of the sensor (whether it be film or digital) and the resolution of the optical system. Neither tells the whole story. Those who determine print size solely on the basis of the number of pixels on their sensor will eventually run into optical limitations as pixel densities increase, and those who base it solely on the optics may well run into pixel limitations. Only when one system is vastly better than another will this not be the case.
But that has not proved to be true in practice. Nearly all cameras on the market are limited by the sensor in some cases and by the optics in other cases. The more recent portions of this thread talked about one of those limitations--diffraction--and its effects on very small sensors with high pixel densities in particular.
If one wants absolutely the best possible image quality, then one will seek to find the best balance between the effects of diffraction and the effects of lens faults and too limited a depth of field in any given situation. The solution space may be inadequate for prints beyond a certain size, in which case one will need camera movements, a larger format, or some other method of managing that balance point. Knowing that relationship will help keep disappointment at bay, for those who don't mind modeling things in math rather than learning them by experience.
I will never forget the disappointment I felt when my first 4x5 negatives, shot at f/45 using short lens, would not support a 20x30" print when viewed up close. I learned that f/32 gave me the needed results for such prints with that lens, and if that didn't provide enough depth of field, then I needed to make use of camera movements to adjust the depth of field to meet my priorities. I wish I'd spent a bit of time thinking about apertures before that first disappointment--every field session with that camera was difficult and consumed opportunities that were hard to repeat.
The standard you propose--4x6" prints viewed at 10 inches--is not particularly demanding and widens the solution space between the effects of diffraction and the effects of lens faults and too limited a depth of field. In practice, you probably will not experience any problem with this issue using most any digital camera.
But can one enlarge to the full potential of a 3x5mm 6-megapixel sensor? Not without seeing the limitations of the optical system, particularly diffraction. Thus, the maximum enlargement on such cameras will be limited by optical issues moreso than by pixel density.
When we get to the point where such densities pose no problem of convenience, then it won't matter. Even if a pixel only sees something marginally useful by itself, we will be integrating large numbers of pixels together when we make any reasonable print--"reasonable" meaning any print that is supportable by the optics. The errors of too small a pixel will average out.
But too many pixels still poses a challenging problem of memory card size, processing power, storage, and so on. So it makes sense to choose a pixel density that is appropriate for the format and optics--and for the objectives of the photographer. Pixel density and format (which is a surrogate for pixel count given a particular pixel density) go hand in hand when choosing a camera.
Rick "summarizing some salient truths for those unwilling to read the whole thread and delve into the arithmetic" Denney