RE: [HACKERS] Optimizer hints

> Hannu Krosing wrote:
> 
> John Ridout wrote:
> > 
> > Hi,
> > 
> > I know of course that the pgsql optimizer is never wrong
> 
> :) 
> 
> OTOH, it is never completely right either :)
> 
> > but for the sake of argument do you think we could have
> > optimizer hints the way say MSSQL has them?
> 
> I think it has been discussed (a little) but more on the 
> lines of 'the way Oracle has them' ;)
> 

Oh, you mean properly.

> It seems that this is not currently very high priority for 
> any of the current real developers, but if you would 
> contribute a nice clean implementation I'm sure it would 
> be accepted.
> 
> ----------------
> Hannu
> 

Come the end of September I will have enough time
to play with the internals of pgsql.
I suppose there are more useful things that
can be done before optimizer hints such as nearly
everything on the TODO list.

John.