The Lock Queue: Why a 2 ms ALTER TABLE Can Freeze Production

You can watch this outage happen on your own machine in about a minute. All it takes is three database sessions and an ALTER TABLE that, on its own, finishes in milliseconds. Most zero-downtime migrat