Re: [HACKERS] SDP query optimizer

2013-03-23 Thread Adriano Lange
Hi, On 22-03-2013 21:22, Josh Berkus wrote: Woah! Way cool. As a warning, we're in the closing throes of version 9.3 right now, so if you code/ideas doesn't get the attention it deserves, that's why. Ok. No problem. :-) There is an incomplete project from a few years back to make the

Re: [HACKERS] SDP query optimizer

2013-03-23 Thread Andres Freund
On 2013-03-22 20:35:43 -0300, Adriano Lange wrote: Hi all, I have developed a new query optimizer for PostgreSQL and I would like to share it with the community. The optimizer's name is Sampling and Dynamic Programming (SDP). I put it into a plugin developed some years ago, named LJQO:

Re: [HACKERS] SDP query optimizer

2013-03-23 Thread Adriano Lange
On 23-03-2013 10:15, Andres Freund wrote: I just want to mention that unless you skew the statistics for the individual tables from their empty/default state this mostly measures a pretty degenerate case where optima are very rare and not very differentiated. Thats a useful thing to test, but

Re: [HACKERS] SDP query optimizer

2013-03-22 Thread Josh Berkus
Adriano, I have developed a new query optimizer for PostgreSQL and I would like to share it with the community. The optimizer's name is Sampling and Dynamic Programming (SDP). I put it into a plugin developed some years ago, named LJQO: Woah! Way cool. As a warning, we're in the closing

Re: [HACKERS] SDP query optimizer

2013-03-22 Thread Ants Aasma
On Sat, Mar 23, 2013 at 1:35 AM, Adriano Lange alange0...@gmail.com wrote: I have developed a new query optimizer for PostgreSQL and I would like to share it with the community. The optimizer's name is Sampling and Dynamic Programming (SDP). I put it into a plugin developed some years ago,