[SERVER-21511] Improve shard targeting for $text queries Created: 17/Nov/15  Updated: 28/Dec/23

Status: Backlog
Project: Core Server
Component/s: Querying, Sharding
Affects Version/s: None
Fix Version/s: None

Type: Improvement Priority: Major - P3
Reporter: J Rassi Assignee: Backlog - Query Integration
Resolution: Unresolved Votes: 2
Labels: qi-text-search
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Assigned Teams:
Query Integration
Sprint: QuInt E (01/11/16), Query F (02/01/16), Query 10 (02/22/16)
Participants:

 Description   

Currently, sharded $text queries almost always target all shards (i.e. scatter-gather), even if they are AND-related to a simple range scan on the shard key. Instead, $text queries should be targeted using the normal query targeting logic. Special-casing $text queries was previously necessary when planning $text queries on mongos was not allowed, but this restriction was relaxed in the implementation of SERVER-19510.

The query planner still cannot generate a plan for $text queries without a text index.



 Comments   
Comment by Githook User [ 06/Jun/16 ]

Author:

{u'username': u'dhatch', u'name': u'David Hatch', u'email': u'david.hatch@mongodb.com'}

Message: SERVER-21511 Add more descriptive TODO.

In mongos, $text queries are always evaluated with scatter-gather,
even when a text index exists on the collection. SERVER-21511
tracks fixing this limitation, which cannot yet be resolved without
improvements in mongos' use of the query planner for chunk index bounds
selection.
Branch: master
https://github.com/mongodb/mongo/commit/f9bf8a5ba0e3397a37f55a2fbca9abe854f863d7

Comment by Githook User [ 06/Jun/16 ]

Author:

{u'username': u'dhatch', u'name': u'David Hatch', u'email': u'david.hatch@mongodb.com'}

Message: SERVER-21511 Add more descriptive TODO.

In mongos, $text queries are always evaluated with scatter-gather,
even when a text index exists on the collection. SERVER-21511
tracks fixing this limitation, which cannot yet be resolved without
improvements in mongos' use of the query planner for chunk index bounds
selection.
Branch: master
https://github.com/mongodb/mongo/commit/f9bf8a5ba0e3397a37f55a2fbca9abe854f863d7

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