Re: A query planner that learns - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: A query planner that learns
Date
Msg-id 20061016194756.GB27790@alvh.no-ip.org
Whole thread Raw
In response to Re: A query planner that learns  (Jochem van Dieten <jochemd@oli.tudelft.nl>)
Responses Re: A query planner that learns  (Madison Kelly <linux@alteeve.com>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: "Harpreet Dhaliwal"
Date:
Subject: calling two shared objects in one single function call
Next
From: "John D. Burger"
Date:
Subject: Re: A query planner that learns