Enable caching for layered cursors and their constituents in WT

XMLWordPrintableJSON

    • Storage Engines, Storage Engines - Foundations
    • SE Foundations - 2025-08-01, SE Foundations - 2025-07-18
    • 8
    • Disag_M9

      The current cursor caching in WT only caches URIs that start with "file:" or "simple tables" (table: URIs that have no indices or column groups). We may get better performance if we can cache "layered:" tables too. Putting a "layered:" cursor in cache will mean closing (caching) the constituent cursors: ingest and stable.

      If we're already caching the constituent cursors, it's not clear how much of a boost this would be, but it probably avoids some config parsing, allocating the WT_CURSOR_LAYERED struct, looking up the dhandle. So probably enough to be noticeable for workloads that use lots of collections, rather than a small number of collections.

        1. image-2025-07-17-09-58-48-958.png
          image-2025-07-17-09-58-48-958.png
          531 kB
        2. image-2025-07-17-13-21-43-289.png
          image-2025-07-17-13-21-43-289.png
          476 kB

            Assignee:
            Jie Chen
            Reporter:
            Donald Anderson
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated:
              Resolved: