Re: parameter hints to the optimizer

Merlin Moncure wrote:
>>Merlin,
>>
>>This will most likely never be accepted by the core team because it is
>>better to spend more time on fixing the planner than to invent some
>>non-standard.
>>As far as I know some databases support a syntax where hints can be
>>hidden in comments or something like that.
>>Meanwhile I think that hints are more of a burdon than a help.
>>
>>    Regards,
>>
>>        Hans
> 
> 
> I thought as much.  Still, the parameter problem is a huge headache.  Maybe if it was possible to use the statistics
togather a 'pseudovariable' to feed to the parameter based on some algorithm, the planner could give better results
withoutexposing the planner inner workings to the user.
 
> 
> Thanks for the feedback.
> Merlin



Using statistics is exactly what the planner does ...
So why should data coming from the planner being given back to the 
planner? Doesn't make sense.

For more information I highly recommend Tom's talk at Oreilly's some 
time ago. I think it is called "recent improvements in 7.4" ...
regards,
    Hans



-- 
Cybertec Geschwinde u Schoenig
Schoengrabern 134, A-2020 Hollabrunn, Austria
Tel: +43/720/10 1234567 or +43/664/816 40 77
www.cybertec.at, www.postgresql.at, kernel.cybertec.at