Loading...

XML

Word

Printable

JSON

Type: Improvement
Resolution: Fixed
Priority: Major - P3
Fix Version/s: 8.1.0-rc0
Affects Version/s: None
Component/s: None
Labels:
- D-QE-ID5

Assigned Teams:

Query Execution
Backwards Compatibility:
Fully Compatible
Linked BF Score:
0
Confidence Status:
None
Work Order:
3
CAR Domain/s:
None

Aha! Reference:
None
Tracking Level:
None
Risk Status:
None
Exec Notes:
None
Goal Name(s):
None
Goal Link:
None

When scanning multi-key indexes, deduplication can consume unbounded amount of memory. In Classic we introduced more memory-efficient solution in ~~SERVER-87976~~.
We should do the same for SBE.

is related to

SERVER-97929 UniqueStage should spill if allowDiskUse is specified and memory usage has exceeded some limit

Open

related to

SERVER-87976 Use roaring bitmaps for RecordId deduplication in IndexScan stage

Closed

Assignee:: Rui Liu
Reporter:: Ivan Fefer
Participants:: Githook User, Ivan Fefer, Mihai Andrei, Rui Liu, Rushan Chen
Votes:: 0 Vote for this issue
Watchers:: 9 Start watching this issue

Created:: Nov 26 2024 11:51:57 AM UTC
Updated:: Jun 13 2025 03:01:59 PM UTC
Resolved:: Feb 04 2025 04:45:43 PM UTC
Confidence Status Last Update:: 20/Jan/25 12:36 PM

Details

Description

Attachments

Issue Links

Forms

Activity

People

Dates