The good news is that recently Photos has stopped beachballing for me (≈170GB library). It now just crashes instead.