How helpful are deadlines really?

Deadlines can be very stressful. Especially when they pile up. But we can't live with no deadlines at all. There is a formula that says: the shorter the deadline, the more efficient the work. But when are deadlines helpful and when are they harmful?