Efficient Multi-deletes

    • Type: Epic
    • Resolution: Won't Do
    • Priority: Major - P3
    • None
    • Component/s: None
    • None
    • Truncate command for clustered collections with secondary indexes
    • None
    • None
    • None
    • None
    • None
    • Needed
    • Hide

      PM-2227 exposes a new BATCHED_DELETE query execution stage for efficiently deleting large ranges of data in batches. This stage is a more performant alternative to the classic DELETE stage and is available for internal operations, and enabled by default for user-initiated multi:true deletions.

      Show
      PM-2227 exposes a new BATCHED_DELETE query execution stage for efficiently deleting large ranges of data in batches. This stage is a more performant alternative to the classic DELETE stage and is available for internal operations, and enabled by default for user-initiated multi:true deletions.
    • None
    • None
    • None
    • None
    • None
    • None

      Downstream Change Summary

      This will have a new oplog entry, so we expect a lot of downstream impacts.

      Description of Linked Ticket

      Epic Summary

      Summary

      Allow the truncate command, developed by PM-2375, to efficiently range-delete clustered collections that have secondary indexes.

      Motivation

      The truncate operation will allow more efficient TTL deletes of time-series buckets, and it will allow Serverless clustered collections to efficiently delete data over arbitrary ranges.

      Cast of Characters

      Documentation

      Scope Document
      Technical Design Document

            Assignee:
            Unassigned
            Reporter:
            Backlog - Core Eng Program Management Team
            None
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved:
              None
              None
              None
              None
              None
              None