If your engine over-compresses the fuel prior to the spark, the fuel might self-ignite, or pre-ignite. You hear this as pinking /pinging /knocking. Pinking over a long period can damage the engine.
Modern engines have a microphone that detects the pinking sound, whereupon the computer adjusts the ignition timing - which then spoils performance and efficiency.
The higher the octane rating of the fuel, the higher its ignition temperature, and the smaller its tendency to self-ignite, compared with a high-octane fuel at the same compression ratio. Over-compression is more likely in a car with a higher compression-ratio (which usually means a high performance car) -- so engines with a higher CR require fuel with a higher octane rating, to reduce the tendency to pinking.
If you hear the pinking noise, you can make it disappear by easing off on the gas -- as an alternative to switching to a high-octane fuel.
A supercharger on your engine increases the compression-ratio as seen by the fuel, which makes pinking more likely, and therefore a supercharger makes the use of a higher octane more of a necessity.
Another bad effect of higher CR arises because car engines use air rather than oxygen. A car engine is a machine that turns carbon into carbon oxides -- but is also a machine that turns nitrogen into nitrogen oxides. Emission of nitrogen oxides becomes a problem in cars with the higher CRs. The use of higher octane does not save the nitrogen from being turned into (toxic) N-oxides.
The octane rating has nothing to do with how much energy the fuel gives when it burns -- except that pinking wastes some of the fuel's energy - as does changing the ignition timing. Easing off on the gas saves energy - but wtf?