You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Vladimir Sitnikov (Jira)" <ji...@apache.org> on 2020/01/05 12:59:00 UTC

[jira] [Created] (CALCITE-3708) Make VolcanoCost account cpu and io properties when comparing costs

Vladimir Sitnikov created CALCITE-3708:
------------------------------------------

             Summary: Make VolcanoCost account cpu and io properties when comparing costs
                 Key: CALCITE-3708
                 URL: https://issues.apache.org/jira/browse/CALCITE-3708
             Project: Calcite
          Issue Type: New Feature
          Components: core
    Affects Versions: 1.21.0
            Reporter: Vladimir Sitnikov
            Assignee: Vladimir Sitnikov


Currently, {{VolcanoCost}} compares {{rows}} only, which does not allow for proper cost comparison of joins, projections, filters.

The idea is to use {{cpu + io * cpuPerIo}} calculation for comparison, and ignore {{rows}} part.
{{cpuPerIo}} could be configured with {{org.apache.calcite.config.CalciteConnectionConfig#volcanoCostIoPerCpu}} which comes from {{volcanoCostIoPerCpu}} connection property and defatlts to {{calcite.volcano.default.cpu_per_io}} system property.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)