Last point TS Opt M3: TSBS insert performance experiment with doubled indexes

XMLWordPrintableJSON

    • Type: Task
    • Resolution: Done
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • QO 2022-03-21
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None

      We need to measure the performance impact of our proposed solution to the reverse DISTINCT_SCAN for $sort+$group+$last.

      There's no need to merge anything, but we should try updating the TSBS insert tests to manually include indexes on the missing {meta, min, max} or {meta, max, min} bucket index for each defined {meta, time} index.  After doubling the number of indexes, how is performance affected?  If there's not much change, we can proceed confidently with the plan to double these indexes.

        1. tsbs_load_slow.png
          tsbs_load_slow.png
          152 kB
        2. tsbs_load_slow_3node.png
          tsbs_load_slow_3node.png
          162 kB
        3. tsbs_load_manual.png
          tsbs_load_manual.png
          142 kB
        4. tsbs_load_manual_3node.png
          tsbs_load_manual_3node.png
          154 kB
        5. tsbs_load_fast.png
          tsbs_load_fast.png
          152 kB
        6. tsbs_load_fast_3node.png
          tsbs_load_fast_3node.png
          161 kB

            Assignee:
            Alya Berciu
            Reporter:
            Steve Tarzia
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: