Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-84944

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

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

      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_fast_3node.png
          tsbs_load_fast_3node.png
          161 kB
        2. tsbs_load_fast.png
          tsbs_load_fast.png
          152 kB
        3. tsbs_load_manual_3node.png
          tsbs_load_manual_3node.png
          154 kB
        4. tsbs_load_manual.png
          tsbs_load_manual.png
          142 kB
        5. tsbs_load_slow_3node.png
          tsbs_load_slow_3node.png
          162 kB
        6. tsbs_load_slow.png
          tsbs_load_slow.png
          152 kB

            Assignee:
            alya.berciu@mongodb.com Alya Berciu
            Reporter:
            steve.tarzia@mongodb.com Steve Tarzia
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: