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

Improve min/max to use vectorized updates (AMD+ ARM)

Details

    • 2021-17

    Description

      The code in primitives/linux-port/column.cpp:vectorizedFiltering suffers calculating min/max values for a block in a scalar manner that takes place in vectWriteRIDValues/vectWriteColValues. According with my observations we can reduce the timings 20% down removing this deficiency.
      Tested with 10**9 int64 records and a simple query 'SELECT c1 FROM t1 WHERE c1 = 5 OR c1 = 10;

      Attachments

        Activity

          Done, after testing (on 10**6 values, for a 30 s period) the increase shown is from 3826 queries to 5612, about 45%.

          Andrey Andrey Piskunov (Inactive) added a comment - Done, after testing (on 10**6 values, for a 30 s period) the increase shown is from 3826 queries to 5612, about 45%.
          drrtuy Roman added a comment -

          4QA this optimization should benefit query processing(that has filters on numbers or column types that are reduced to numbers) in general. The query example is mentioned in the description.

          drrtuy Roman added a comment - 4QA this optimization should benefit query processing(that has filters on numbers or column types that are reduced to numbers) in general. The query example is mentioned in the description.

          Build verified: 22.08-1 (#5243)

          Closed by regression test

          dleeyh Daniel Lee (Inactive) added a comment - Build verified: 22.08-1 (#5243) Closed by regression test

          People

            dleeyh Daniel Lee (Inactive)
            drrtuy Roman
            Roman Roman
            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.