LED is the most efficient. It is getting cheaper and has an extremely long lamp life.
Mercury vapor and fluorescent are pretty much the same thing. The old style fixture and lamp were about as inefficient as it gets. The newer versions with electronic ballasts work well down in the temperature range at pretty good efficiency.
High and Low pressure Sodium (HID)the Low pressure puts off a narrow band or yellow light making color rendition near impossible. The High pressure units cause strobing effects on the highways(tires turning backwards) but have much more efficiency than the Low units and better color.
It's what you want that matters.