Re: CockroachDB optimizer
I guess it's not a volcano planner but a cascades style planner. Calcite
is the volcano style. Some common notion like 'Memo', 'Group',
'Transformation' of Cascades planner can be found from their planner. The
systems like gporca ,prestodb (maybe including the CockroachDB ) implement
the cascade style planner,.
On Fri, Nov 9, 2018 at 9:00 PM Stamatis Zampetakis <zabetak@xxxxxxxxx>
> Thanks for sharing this Michael!
> I had a look on their blog post but I didn't notice something really novel.
> It gives me the impression that they re-implemented a Volcano-style
> optimizer like the one of Calcite.
> Out of curiosity, are they using Calcite, or they really built everything
> from scratch?
> Στις Παρ, 9 Νοε 2018 στις 2:55 π.μ., ο/η Michael Mior <mmior@xxxxxxxxxx>
> > The folks from Cockroch Labs just shared an interesting blog post on the
> > development of their optimizer. Could be some interesting lessons in
> > code base.
> > https://www.cockroachlabs.com/blog/building-cost-based-sql-optimizer/
> > --
> > Michael Mior
> > mmior@xxxxxxxxxx