-
Type: Bug
-
Resolution: Won't Fix
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
-
Query Execution
-
ALL
The Hash Agg stage in the SBE engine spills using a record store as opposed to files as in the classic engine. There is a statistic query execution tracks "spilledDataStorageSize" introduced in https://jira.mongodb.org/browse/SERVER-73311 which reports the bytes spilled to the record store.
When testing this behavior on an in memory required build variant, the value of spilledDataStorage size is 0, even though spilling is allowed. ([patch build: ).
This poses the question:
Should we even allow spilling to record stores when running on an in memory build?
If no, we can disable spilling when in memory stores.
If yes, we can spill to a file instead of record store, or ignore the memory limit.
- is related to
-
SERVER-36388 inMemory storage engines should not set allowDiskUse for external sorts
- Closed
- related to
-
SERVER-73757 Calling storageSize() on ephemeral temporary record stores returns 0
- Backlog
-
SERVER-74335 Spill to disk tests for $group must be tagged as "requires_persistence" on the v6.0 branch
- Closed