"Jonah H. Harris" <jonah.harris@gmail.com> writes:
> On Fri, Nov 14, 2008 at 11:43 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> IMHO, the only thing worse than an unstable plan is a stable one.
> Your opinion contradicts the majority of the industry then, I'm
> afraid. Like query hints, people are sometimes smarter than the
> optimizer.
And, very often, they're not --- or more likely, they were smarter than
the optimizer last year, but now conditions have changed. Failing to
adapt to new conditions is exactly the problem with query hints, and
in general with any insistence that plans should be "stable".
regards, tom lane
