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

Truncate TemporaryRecordStores for query spilling before dropping

    • Type: Icon: Improvement Improvement
    • Resolution: Won't Do
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Storage Execution

      Because WT prevents us from dropping a table until it has been checkpointed, if I have a query that spills and completes within the span of a single checkpoint, currently we must checkpoint everything in the table just to delete it, which is a waste of work.

      The WiredTiger fast-truncate can remove the contents of a table very efficiently without performing unnecessary page reads. Before queueing the table for being dropped, we truncate the contents of the table, we avoid creating extra work for the next checkpoint.

            Assignee:
            backlog-server-execution [DO NOT USE] Backlog - Storage Execution Team
            Reporter:
            louis.williams@mongodb.com Louis Williams
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: