[deniska]

Why it's good: you won't get a sudden slowdown if postgresql for some reason changes its plan to something much less performant.

[silon42]

Yup... parent point 1 is an often a misfeature in production (yes, sometimes the plan is better, but sometimes not).