Originally posted by RXrenesis8 16....3.....12
11....6.....25
8.....12....50
This table oversimplifies a bit.
The easiest rule of thumb is that the resolution limit is at N/3 micron pixel sizes where N is the F-stop. So, for a 5 micron pixel sensor (K-5, D800), the limit would be hit at F/15. I.e., you need a diffraction limited lens at F/15 or better. This is quite a bit more optimistic than the table above.
However, you see a significant impact up to N/1.5 micron pixel sizes. Where micro contrast is weakened (by 50% or more) but not destroyed. That's a region to be avoided but not the limit. For 5 micron pixels, it means to better stay below F/8.
The very best SLR lenses peak at F/2.8 in the center, but F/4 is considered excellent too. Many lenses peak at F/8 in the corners though. The lesser lenses peak at F/8 even in the center.
But this entire discussion is meaningless. APSC SLRs have other problems which will prevent to exploit the full lens resolutions. Like defocus blur and shake. E.g., consider the 1/f shutter rule, meaning that a 50mm lens causes 30 microns blur (the coc) at 1/50s. So, if you want to eliminate shake with 3 microns pixels, you need 1/500s shutter speeds. Of course, an SR helps, but will it freeze your subject? So, what you need then is more light. APSC has resolution limits which aren't defined by the lens.