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
