Re: [PERFORM] [HACKERS] Proposal: Pluggable Optimizer Interface

2007-08-13 Thread Tom Lane
Josh Berkus <[EMAIL PROTECTED]> writes: > Tom, >> Also, while we might accept >> a small hook-function patch for 8.3, there's zero chance of any of that >> other stuff making it into this release cycle. > I don't think anyone was thinking about 8.3. This is pretty much 8.4 > stuff; Julius is jus

Re: [PERFORM] [HACKERS] Proposal: Pluggable Optimizer Interface

2007-08-13 Thread Josh Berkus
Tom, > Also, while we might accept > a small hook-function patch for 8.3, there's zero chance of any of that > other stuff making it into this release cycle. I don't think anyone was thinking about 8.3. This is pretty much 8.4 stuff; Julius is just raising it now becuase they don't want to go d

Re: [PERFORM] [HACKERS] Proposal: Pluggable Optimizer Interface

2007-08-13 Thread Tom Lane
Julius Stroffek <[EMAIL PROTECTED]> writes: > I understood that if the user creates his own implementation of the > planner which can be stored in some external library, he have to provide > some C language function as a "hook activator" which will assign the > desired value to the planner_hook

Re: [PERFORM] [HACKERS] Proposal: Pluggable Optimizer Interface

2007-08-13 Thread Julius Stroffek
Stefan, thanks for pointing this out. I missed this change. We would like to place the hooks to a different place in the planner and we would like to just replace the non-deterministic algorithm searching for the best order of joins and keep the rest of the planner untouched. I am not quite

Re: [PERFORM] [HACKERS] Proposal: Pluggable Optimizer Interface

2007-08-13 Thread Tom Lane
Stefan Kaltenbrunner <[EMAIL PROTECTED]> writes: > Julius Stroffek wrote: >> There is a proposal attached to this mail about the interface >> we would like to implement for switching between different >> optimizers. Please review it and provide a feedback to us. > hmm - how does is that proposal d

Re: [PERFORM] [HACKERS] Proposal: Pluggable Optimizer Interface

2007-08-13 Thread Stefan Kaltenbrunner
Julius Stroffek wrote: > Hi All, > > Tomas Kovarik and I have presented at PGCon 2007 in Ottawa > the ideas about other possible optimizer algorithms to be used > in PostgreSQL. > > We are quite new to PostgreSQL project so it took us some > time to go through the sources end explore the possibil