Re: Overriding the optimizer

[Christopher Kings-Lynne <chriskl@xxxxxxxxxxxxxxxxxxx>]

> > ... This seems like a case where PostgreSQL's current optimiser should 
> > easily know what to do if your config settings are correct and you've 
> > been running ANALYZE, so I'd like to see your settings and the explain 
> > analyze plan...
>
> I could, but it would divert us from the main topic of this discussion.  
> It's not about that query, which was just an example.  It's the larger 
> issue.

So your main example bad query is possibly just a case of lack of 
analyze stats and wrong postgresql.conf config?  And that's what causes 
you to shut down your database?  Don't you want your problem FIXED?

But like I said - no developer is interested in doing planner hints. 
Possibly you could get a company to sponsor it.  Maybe what you want is 
a statement of "If someone submits a good, working, fully implemented 
patch that does planner hints, then we'll accept it."

Chris