OK, here comes a novel, so open up on a computer screen LOL
Regarding your question "
Why does the 4MP require IR illumination and then does a horrible job even with that? Surely this can't be attributed to just the point of this thread: Digital zoom + 4MP vs Optical zoom + 2MP as I understand the "digital zoom" was done after the recording when the image was already black and white."
The answer is simple. The 4MP didn't require IR illumination - That camera was not set up to IDENTIFY at that distance, but rather up close within 10-15 feet of the camera and I CHOOSE to run it in B/W for the faster shutter to get a cleaner capture. That 4MP runs fine in color and is actually brighter than the 2MP.
This post was an afterthought long after those images were taken or I would have done a color to color comparison (but wait I have something close).
However, I am always tweaking my cams and will bounce back and forth between B/W and color and I happen to have a similar shot of the 4MP fixed lens in color from a different day.
So since you asked, the image on the left is the 4MP 5442 DIGITALLY ZOOMED in color (different day than the other two); the middle one is the 4MP 5442 DIGITALLY ZOOMED in B/W; and the right is the 2MP 5442 OPTICALLY ZOOMED and as you can see whether it was B/W or color, digital zoom doesn't provide as good of an image as the optical zoom.
So in theory, the 4MP B/W was at its best opportunity to get a clean digital image due to the white light and Infrared light it was getting and that is also kinda evident comparing the 4MP color versus B/W images.
So as you can see, your question "
This particular post with the purpose of this thread appears to say that a digitally zoomed 4MP camera image will be a messy B/W while an optically zoomed 2MP camera would stay in color. Is that the case? " The answer is NO as this shows that whether it was in color or B/W, at night with limited light, it will be a messy digital zoomed image whether it is in color or B/W, but the B/W would stand a better chance due to seeing infrared light and an OPTICALLY zoomed camera will produce the best image for a set distance.
Regarding your question
"Particularly, I want to know if for the same sensor size a 4 MP camera will be penalized in low light conditions compared to a 2 MP camera, and if so, would the penalty be reduced if the 4 MP camera's resolution is reduced to the 2 MP equivalent, or the native resolution is what dictates the maximum performance?"
The answer is an emphatic YES it will be penalized and downrezing a 4MP to 2MP does not work. The native resolution dictates the maximum performance.
A 4MP on the same size sensor as a 2MP will need DOUBLE the light of the 2MP.
Downrezing a camera does not work - It is still using the 4 million pixels - the camera doesn't change the "pixel resolution screen" on the camera when you go from 4MP to 2MP. The sensor still needs 2 times the light going from 4MP to 2MP, so the native 2MP camera will result in a better image at night. The firmware will make some algorithm attempt at downrezing it, but it could be a complete crap image or a somewhat usable image, but if there is a concern that the 4MP isn't performing or wouldn't perform well at night, then it is better to go with the 2MP.
What you are failing to realize is there is more "pixel screen" material on the 4MP, so two cameras of different MP on the same size sensor will result in the higher MP having more opaque "screen" material that impacts how much light gets thru. So two different cams on same sensor means the lower MP will allow more light on the sensor.
Use a Window for example. Which one is clearer to look thru the one with a screen or one without? The more holes a screen is produced with, the more material there is as well.
These sensors are small and we need to get as much light to them as possible.
An analogy to try to understand why cameras need so much more light - let's look at an 8MP camera and this 8MP needs at least four times the amount of light as a 2MP for the same sensor. The sensor size is the same in each camera, but when you spread the "screen" of 8MP worth of pixel holes across the same sensor, it now has 4 times the holes, but also 4 times the "screen material" than the 2MP.
Kind of hard to explain, but lets try to use a window screen as an analogy - take a window where the opening is fixed - that is the sensor - you add a screen to it (that represents 2MP) and looking out through the screen is a little darker outside because of the screen material. Now replace that screen with one that has four times the amount of holes (now it represents 8MP) and it will be darker looking through it because (while the resolution would be better) there is a lot more screen material.
So if your house is like most where the top pane is glass with no screen and the bottom half is window with the screen and you see something outside during the daytime - do you sit down to look out through the screen or do you stand up to look a the object through the window with no screen?
And that is accentuated even more at night time. Look out your window with and without the screen and it will be darker looking through the screen than without it. If you are looking out your window to see the stars or the moon, do you look out the part of the window with the screen, or the upper portion without the screen material?
Now obviously as it relates to a camera, you need to balance the amount of pixel holes with the screen material - too few holes (and thus less screen material) and the resolution suffers, and too many holes (and thus more screen material) and the more light that is needed.
Look at a window screen and available meshes. The actual window opening does not change size, so that is the sensor. The screen material is the "pixel screen" that makes up the MP. Which one of these is going to let more light thru?
So if you are taking a 22 mesh screen and trying to get the same amount of brightness thru into the house as the 4 or 14 mesh screen, it will need A LOT more light.
A close comparison would be the 22 mesh screen is an 8MP and the 14 mesh is a 4MP. So if you have the same amount of light going thru a 14 mesh screen as you do a 22 mesh screen, it will be darker for the 22 mesh screen and any parameter adjustment you do to brighten it (gain, iris, brightness) will add more noise.
Even if the downrez from 4MP to 2MP happens before any other processing, it is still starting with a darker image than a native 2MP camera so that will introduce more artifacts.
This is how outside sun shades work. The darker/more shade it provides, the more holes the shade has. More holes equals more screen material which means more light that is needed to penetrate it.
I have a 4MP and 2MP on the same 1/2.8" sensor and the picture quality is quite different between the two and the 2MP kicks it's butt at night.
Now this is where you can see the difference about can a camera run in color or B/W for two different MP cameras on the same size sensor.
In most instances, you want to get a camera that will perform at your location for the worse situation, which for most of us is at night when it is dark and there is little to no light. If a camera performs at night, it is easier to tweak settings to make it work during the day than it is the other way around.
My 2MP cameras outperform my neighbors 4K (8MP) cameras....why....because they are both on the same size sensor.
When we had a thief come thru here and get into a lot of cars, the police couldn't use one video or photo from anyone's system but mine. Not even my other neighbors $1,300 8MP system provided useful info - the cams just didn't cut it at night.
My neighbor tried the "I will just downrez the 8MP to 2MP" and the image was a soft dark mess.
His system wasn't even a year old and after that event has started replacing with cameras purchased from
@EMPIRETECANDY here based on my recommendation and seeing my results. He is still shocked a 2MP camera performs better than his 4k cameras and he cannot figure out why downrezing from 8MP to 2MP doesn't work properly... It is all about the amount of light needed and getting the right camera for the right location and downrezing doesn't change the physics of the camera.
Here is a real world example from a 2MP and 4MP model camera on the same size sensor.
Here is the 2MP on the 1/2.8" sensor. It deems it has enough light at a 1/60 shutter so it stays in color:
Here is the same camera model except it is a 4MP on the same 1/2.8" sensor as the 2MP above.
Here is the first big issue you see with a double the resolution on the same size sensor - It deems that it does not have enough light at a 1/60 shutter so it goes to B/W with Infrared:
So one thinks, "hey why don't I just make the 4MP camera a 2MP resolution and it will perform like a 2MP resolution camera" The first thing you notice is that downrezing the 4MP down to a 2MP doesn't result in the camera being able to run color like the native 2MP as the sensor still doesn't see enough light to run in color because the 4MP "pixel screen" simply isn't letting enough light get into the optics of the sensor.
That is a big deal with low light conditions and why you want to go with a native resolution and preferably a camera on the ideal MP/sensor ratio that is talked about here often. The native resolution may be able to be in color, but the higher resolution on the same size sensor probably won't with low light conditions.
Then in this case, you can see that the 4MP was struggling to even give definition compared to the 2MP. It is wet out so the rain reflections is wreaking havoc with the infrared and focus.
So when I downrezed but kept the bitrate the same, it still looks like a soft mess. Even if there is less noise in this instance, it still doesn't look as good as the native.
And the less light that is available, the bigger the difference one will see. Personally, for me the difference between being able to run it in color versus B/W is enough of a reason to go with the the camera that is on the ideal MP/sensor ratio talked about here so much.
As always YMMV.