Hacker News Reader

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

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