Howabout a simpler explanation? Cool technobabble is fine, but it doesn't do any good if nobody knows WTF you're talking about.
The basic rundown: You can run compression as high as you really want, until you run into problems with detonation. There is no hard-set rule about how high you can go on normal gasoline either, it's just a "try it and see how it works" thing.
Typically, very high compression engines suffer from detonation -- the fuel explodes before the engine is ready. Thus, your engine is still trying to "Squish" on that explosion and it makes pinging noises. Squishing an explosion is a very abusive thing to do to an engine which is why you damage engine parts when it's pinging.
But compression isn't the only factor that makes an engine ping... As you're well aware, higher octane gasoline is more resistant to detonation mostly because it burns slower. If you're getting pinging, higher octane gas will usually fix it. This is also why higher octane fuels don't do much for you when your car is NOT pinging.
However, there's even MORE cool stuff that makes your engine more resistant to detonation. For example: if the gasoline is very well atomized (a VERY fine and even mist) in the air, then it will burn cooler and in a more controlled fashion. This can be accomplished by better or more advanced fuel injection systems, better intake manifold design, and even by the way the pistons interact with the cylinder head.
Other things include dynamic compression ratio, where you figure how much ACTUAL compression you're getting based on how your cams are arranged. You can also talk about removing "hot spots" from the engine through better piston, combustion chamber and engine cooling design. A hot spot will make the fuel ignite before it's ready which leads to pinging -- so keeping hot spots out can also help.
Basically what it comes down to is this: The maximum compression you can run totally depends on what kind of fuel you want to use, what kind of cams you want to use, how much tradeoff you want for emissions versus power and the overal design of the internal combustion chamber space.
Make a little more sense?
-Red-