Benjamin Graham wrote that everyone should hold between 25% and 75% in equities, with the rest in bonds. The right level is the point where you sleep easy.
Why do people have trouble shifting from a saving to spending mindset in retirement? Researchers have plenty of theories though can't identify an exact cause, nevertheless there are things that can enable the shift.