Jochem van Dieten wrote: > Scott Marlowe wrote: > >While all the talk of a hinting system over in hackers and perform is > >good, and I have a few queries that could live with a simple hint system > >pop up now and again, I keep thinking that a query planner that learns > >from its mistakes over time is far more desirable. > > > >Is it reasonable or possible for the system to have a way to look at > >query plans it's run and look for obvious mistakes its made, like being > >off by a factor of 10 or more in estimations, and slowly learn to apply > >its own hints? > > Technically it is very feasible. But I think you might want to check US > Patent 6,763,359 before you start writing any code. I think it would be a very good idea if you guys stopped looking at the US patent database. It does no good to anyone. There's no way we can avoid stomping on a patent or another -- there are patents for everything. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.
