Re: GSoC idea - Simulated annealing to search for query plans - Mailing list pgsql-hackers

From Fabrízio de Royes Mello
Subject Re: GSoC idea - Simulated annealing to search for query plans
Date
Msg-id CAFcNs+qYU-un5fVEHTccaPc0EcFCWhmuqFFb+Ncp7ErSU3-+QA@mail.gmail.com
Whole thread Raw
In response to Re: GSoC idea - Simulated annealing to search for query plans  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-hackers
<div dir="ltr"><div class="gmail_extra"><br />On Thu, Feb 26, 2015 at 10:27 PM, Andres Freund <<a
href="mailto:andres@2ndquadrant.com">andres@2ndquadrant.com</a>>wrote:<br />><br />> On 2015-02-26 20:23:33
-0500,Tom Lane wrote:<br />> > Josh Berkus <<a href="mailto:josh@agliodbs.com">josh@agliodbs.com</a>>
writes:<br/>> > > On 02/26/2015 01:59 PM, Grzegorz Parka wrote:<br />> > >> I'm interested in one
ofold TODO items related to the optimizer -<br />> > >> 'Consider compressed annealing to search for query
plans'.<br/>> ><br />> > > You might look at the earlier attempt to make the GEQO replacement<br />>
>> "pluggable".  That project failed to complete sufficiently to be a<br />> > > feature though, but it
didenough to show that our current GEQO<br />> > > implementation was suboptimal.<br />> ><br />>
>> I'm currently searching for this project ... it was a GSOC project, but<br />> > > I think before
theyrequired posting to Google Code.<br />> ><br />> > I seem to recall somebody demo'ing a
simulated-annealingGEQO replacement<br />> > at PGCon a couple years back.  It never got to the point of being
a<br/>> > submitted patch though.<br />><br />> Yea, it was Jan Urbański (CCed).<br />><br /><br />And
theproject link: <a href="https://github.com/wulczer/saio">https://github.com/wulczer/saio</a><br /><br />Regards,<br
/><br/>--<br />Fabrízio de Royes Mello<br />Consultoria/Coaching PostgreSQL<br />>> Timbira: <a
href="http://www.timbira.com.br">http://www.timbira.com.br</a><br/>>> Blog: <a
href="http://fabriziomello.github.io">http://fabriziomello.github.io</a><br/>>> Linkedin: <a
href="http://br.linkedin.com/in/fabriziomello">http://br.linkedin.com/in/fabriziomello</a><br/>>> Twitter: <a
href="http://twitter.com/fabriziomello">http://twitter.com/fabriziomello</a><br/>>> Github: <a
href="http://github.com/fabriziomello">http://github.com/fabriziomello</a></div></div>

pgsql-hackers by date:

Previous
From: Amit Langote
Date:
Subject: Re: Partitioning WIP patch
Next
From: Gavin Flower
Date:
Subject: Re: logical column ordering