[Join Optimization] Consider the size of the OS filesystem cache for IO estimation

XMLWordPrintableJSON

    • Type: Improvement
    • Resolution: Unresolved
    • Priority: Minor - P4
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Optimization
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      Currently the join cost model's usage of Mackert Lohman formula for estimation of IOs only considers the size of the WT page cache. In reality, MongoDB also caches pages in the OS page cache as well, making the effective size of the buffer cache larger, though potentially storing duplicates.

      We could improve our estimate of INLJ/Index scans for collections which result sets which don't fit in memory by considering the effect of the addition cache.

            Assignee:
            Unassigned
            Reporter:
            Ben Shteinfeld
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: