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

Grzegorz Parka writes: > I'm thinking of testing and improving SAIO as an extension before reaching > a satisfactory quality of code and returned plans. > Would then the destination be the /contrib and then main source tree or > would it ever stay as an extension? I'd like to push it into the ma

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

> > I think someone already mentioned it, but it would be very neat if the > optimizer could be pluggable. Then many different algorithms could be > evaluated more easily. Does it mean just to make the join order optimizer pluggable? If yes then it is already pluggable as an extension. Is this th

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

Thank you a lot for your feedback. I searched a lot about GEQO, but I didn't find information about any earlier attempts. I'm happy to know that this is important for Postgres. I'm really interested in this project, so I just need to estimate if I can handle it. Now I will spend some time with SAI

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

Josh Berkus writes: > On 02/26/2015 05:50 PM, Fabrízio de Royes Mello wrote: >> >> On Thu, Feb 26, 2015 at 10:27 PM, Andres Freund > > wrote: >>> >>> On 2015-02-26 20:23:33 -0500, Tom Lane wrote: >>> > >>> > I seem to recall somebody demo'ing a simulated-annealing

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

On Thu, Feb 26, 2015 at 10:59:50PM +0100, Grzegorz Parka wrote: > Dear Hackers, > > I'm Grzegorz Parka, BSc Engineer of Technical Physics and student of > Computer Science at WUT, Poland. Last year I've been a bit into > evolutionary algorithms and during my research I found out about GEQO in > Po

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

On 02/26/2015 05:50 PM, Fabrízio de Royes Mello wrote: > > On Thu, Feb 26, 2015 at 10:27 PM, Andres Freund > wrote: >> >> On 2015-02-26 20:23:33 -0500, Tom Lane wrote: >> > Josh Berkus mailto:j...@agliodbs.com>> writes: >> > > On 02/26/2015 01:59 PM, Grzegorz Parka

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

On Thu, Feb 26, 2015 at 10:27 PM, Andres Freund wrote: > > On 2015-02-26 20:23:33 -0500, Tom Lane wrote: > > Josh Berkus 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 s

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

On 2015-02-26 20:23:33 -0500, Tom Lane wrote: > Josh Berkus 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

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

Josh Berkus 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

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

On 02/26/2015 01:59 PM, Grzegorz Parka wrote: > Dear Hackers, > > I'm Grzegorz Parka, BSc Engineer of Technical Physics and student of > Computer Science at WUT, Poland. Last year I've been a bit into > evolutionary algorithms and during my research I found out about GEQO in > Postgres. I also fou

[HACKERS] GSoC idea - Simulated annealing to search for query plans

Dear Hackers, I'm Grzegorz Parka, BSc Engineer of Technical Physics and student of Computer Science at WUT, Poland. Last year I've been a bit into evolutionary algorithms and during my research I found out about GEQO in Postgres. I also found out that there are plans to try a different attempt to