Great to see this analysis. Especially with the proliferation of ORMs that create relationship tables like confetti it is very useful (and comforting) to know that needing to join a large number of tables is not in and of itself a performance disaster. It does not alleviate all my concerns with join-happy designs, but it is definitely good to know.