this is a classic question - and i'll upset everyone again with my advice (which is true).
If you go for something very narrow (eg. 26x1.0 up to 26x1.3) and you run them at high pressure (90 psi) it is extremely likely that you will crack the rim of your wheel.
I read about this happening on the web and thought it was bull, so I was happily running my conti sport contacts 26x1.3 at 85psi for 1200 miles then inspected the rim and found about 6 (yes 6) large cracks in the rim! Lucky that the wheel didn't collapse.
Everyone on CC insists that this doesn't really happen! Well, there are numerous accounts on the web and it happened to me; so I believe it!
The problem is that MTB rims are not designed for narrow high pressure tyres.
I wouldn't go below 26x1.6 and keep the pressure below 70 psi.
I find that difficult to believe.
I cannot imagine a rim manufacturer designing their product to such a small stress limit. They MUST know there will be some aftermarket consumers who will purchase 26 x 1.125 tyres and pump them up to 100 psi. The tyres are on the rack ready to be fitted.
Where is the sticker saying "70 psi MAX".
The rims must have been made from a faulty strip of extrusion.
If anyone has a rim that collapses and the rider is killed as the consequence, American lawyers will take the rim manufacturers to the proverbial cleaners. It wouldn't be in their best interest to design rims that can't withstand 90 psi of pressure in the tyre. If it is seen the rim manufacturers durability test data shows failure with a tyre at 90 psi, they are in deep do-dos.
The difference between identifying a faulty batch and KNOWING the component could fail is a monetary fine or company closure.
Additionally, what about all the rough-stuff treatment MTB wheels get on a downhill course. They should be falling apart everywhere if the metal is that thin.