I've seen 175w mercury yardlights for sale in stores in Canada as late as 2018/2019. They were never banned here so they kept on selling them here until LED basically killed them off along with the HPS yardlights they were selling alongside the MV ones.

Pulse start wasn't that common here until after probe start got banned in the US and by then a lot of places already started using fluorescent high bays instead. Probe start ballasts were still available here long after fixtures got banned in the US as well.

I guess MV wasn’t banned in Canada either.

Some countries still allow MV right now.

And, you are correct about the fluorescent high bays. Pulse start metal halide wasn’t really too popular in wattages over 175 watts. And, Lowe’s, Best Buy, and even gymnasiums, majorly replaced metal halide high bays with fluorescent ones (and now LED). Some places even replaced them with CFL high bays. And, probe start metal halide street lights were commonly just replaced with HPS as they failed, so as a result, PSMH was never too common (except in low wattages). Higher wattage PSMH was normally found on wall packs or on shoeboxes in newer buildings.

PSMH in general is quite uncommon, in both indoor lighting and as street lighting. I think probe start MH cobra heads are actually more common than PSMH ones. I’ve seen more probe start ones, and, PSMH fixtures were frequently mislamped with probe start MH or even mercury lamps because pulse start lamps over 150 watts were notoriously hard to find. PSMH cobras were only really used as spot replacements for mercury vapor or probe start metal halide if used at all. I’m wondering if they actually disconnected  the igniters on those because of the expensive and hard to find lamps, and cities disconnected the igniters to install probe start MH lamps or MV lamps. If MH was used as an upgrade, they were usually installed during the probe start era. Pulse start lamps between 175 and 400 watts are expensive and are hard to find. I think now many of the higher wattage PSMH lamps are discontinued. Another issue with PSMH is they tended to explode at EOL. Much more than probe start lamps. Probe start lamps used vertically on the right ballast don’t normally explode. Oftentimes if there are a bunch of exploded probe start lamps it’s because they’re using the wrong wattage (like a 175 watt lamp on a 250 watt ballast or a 250 watt lamp on a 400 watt ballast). Pulse start lamps will commonly explode even if used correctly.

Some countries might still be making mercury fixtures right now

Ya, Genlux Lighting in South Africa still (to my knowledge) makes a few of their products in MV, as well as MH and HPS.