Re: GSoC idea - Simulated annealing to search for query plans

On Thu, Feb 26, 2015 at 10:27 PM, Andres Freund <andres(at)2ndquadrant(dot)com>
wrote:
>
> On 2015-02-26 20:23:33 -0500, Tom Lane wrote:
> > Josh Berkus <josh(at)agliodbs(dot)com> writes:
> > > On 02/26/2015 01:59 PM, Grzegorz Parka wrote:
> > >> I'm interested in one of old TODO items related to the optimizer -
> > >> 'Consider compressed annealing to search for query plans'.
> >
> > > You might look at the earlier attempt to make the GEQO replacement
> > > "pluggable". That project failed to complete sufficiently to be a
> > > feature though, but it did enough to show that our current GEQO
> > > implementation was suboptimal.
> >
> > > I'm currently searching for this project ... it was a GSOC project,
but
> > > I think before they required posting to Google Code.
> >
> > I seem to recall somebody demo'ing a simulated-annealing GEQO
replacement
> > at PGCon a couple years back. It never got to the point of being a
> > submitted patch though.
>
> Yea, it was Jan Urbański (CCed).
>

And the project link: https://github.com/wulczer/saio

Regards,

--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Timbira: http://www.timbira.com.br
>> Blog: http://fabriziomello.github.io
>> Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello
>> Github: http://github.com/fabriziomello