[SERVER-43683] Make find command with allowDiskUse option work against a view Created: 27/Sep/19  Updated: 29/Oct/23  Resolved: 11/Oct/19

Status: Closed
Project: Core Server
Component/s: Querying
Affects Version/s: None
Fix Version/s: 4.3.1

Type: Improvement Priority: Major - P3
Reporter: David Storch Assignee: David Storch
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
Documented
is documented by DOCS-13096 Investigate changes in SERVER-43683: ... Closed
Related
is related to SERVER-7694 external sort for find command Closed
is related to SERVER-42077 Add 'allowDiskUse' option to find com... Closed
Backwards Compatibility: Fully Compatible
Sprint: Query 2019-10-21
Participants:

 Description   

Today, a find command can be executed against a view which contains blocking stages like $sort or $group that can consume a lot of memory. These stages will fail at runtime if the data size exceeds some memory threshold. If the user runs an aggregate command against the view, they can specify that disk use is allowed during execution of the query. The execution engine will relieve memory consumption by spilling to disk, allowing the query to succeed.

The same cannot currently be achieved with a find command. However, we recently added support for the allowDiskUse option in the find command: see related ticket SERVER-42077. This ticket tracks the work to make sure that the allowDiskUse option is respected when executing a find command against a view, and to add an integration test proving this works correctly.



 Comments   
Comment by Githook User [ 11/Oct/19 ]

Author:

{'name': 'David Storch', 'username': 'dstorch', 'email': 'david.storch@mongodb.com'}

Message: SERVER-43683 Test that 'allowDiskUse' works as expected for find command against views.
Branch: master
https://github.com/mongodb/mongo/commit/b32f535baeaa6832472373c2d19dc2ef33d80c4a

Comment by David Storch [ 09/Oct/19 ]

This behavior already works as expected as of the changes for SERVER-7694. The only remaining work for this ticket is to add an integration test.

Generated at Thu Feb 08 05:03:49 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.