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

$_internalUnpackBucket to return single min/max doc

    XMLWordPrintableJSON

Details

    • Icon: New Feature New Feature
    • Resolution: Won't Fix
    • Icon: Major - P3 Major - P3
    • None
    • None
    • Query Planning
    • None
    • Query Optimization

    Description

      This ticket is optional for PM-2330. 

      SERVER-9507 lets us avoid a full index scan when $group and $first/$last are used together.  PM-2330 extends this optimization to timeseries collections, however it still unpacks the entire bucket containing the first/last data (with $internalUnpackBucket) and then uses a $sort and $last.

      It would be more efficient to have a bucket access operator that directly returned the document for the min/max timestamp.

      Attachments

        Activity

          People

            backlog-query-optimization Backlog - Query Optimization
            ruslan.abdulkhalikov@mongodb.com Ruslan Abdulkhalikov (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: