Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-874

performance regression with dictionary columns

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 1.1.0
    • 1.1.0
    • ExeMgr, PrimProc
    • None
    • 2017-16, 2017-17, 2017-18

    Description

      An aggregate query where the group by column is a char or varchar with dictionary storage appears to be about twice as slow as in 1.0. Normal columns like numbers or inline strings e.g. char(8) are not affected. For example:

      select col2, sum(val), count(*) from sample1 group by 1 order by 1;
      

      if col2 is say char(255)

      Attachments

        Activity

          People

            dleeyh Daniel Lee (Inactive)
            dthompson David Thompson (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.