[SERVER-19097] New geo index version for geo performance improvement Created: 23/Jun/15  Updated: 04/Jun/21  Resolved: 21/Jul/15

Status: Closed
Project: Core Server
Component/s: Geo
Affects Version/s: None
Fix Version/s: 3.1.6

Type: New Feature Priority: Major - P3
Reporter: Siyuan Zhou Assignee: Kevin Albertson
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
is depended on by SERVER-15204 Skip validation for stored geometry i... Closed
is depended on by SERVER-19072 More compact 2dsphere geo index format Closed
is depended on by SERVER-19168 Finer default indexed level for index... Closed
is depended on by SERVER-18921 Index 2DSphere points at finest level Closed
Related
related to SERVER-57448 fix ExpressionParams::parseTwoDParams... Closed
Tested
Backwards Compatibility: Major Change
Sprint: RPL 6 07/17/15, RPL 7 08/10/15
Participants:
Linked BF Score: 70

 Description   

New geo index version is needed for the following performance improvements.
1. SERVER-18921 index 2dsphere points at finest level
2. SERVER-19072 More compact 2dsphere geo index format
3. SERVER-19168 Finer default indexed level for indexing non-point geometries
4. SERVER-15204 Skip validation for stored geometry if a 2dsphere index exists

Upgrade / downgrade should be covered in the tests.



 Comments   
Comment by Siyuan Zhou [ 27/Jul/15 ]

kay.kim@10gen.com LGTM. It should be enough.

Comment by Kay Kim (Inactive) [ 22/Jul/15 ]

Would we need more than:

If you have version 3 2dsphere indexes (i.e. the default version for 2dsphere indexes in MongoDB 3.2), drop the version 3 2dsphere indexes before downgrading MongoDB. After the downgrade, recreate the 2dsphere indexes.

To determine the version of your 2dsphere indexes, run db.collection.getIndexes() to view index specifications. For 2dsphere indexes, the method returns the version information in the field 2dsphereIndexVersion. For example, the following shows that the 2dsphere index on the locations collection is version 3.

Comment by Githook User [ 17/Jul/15 ]

Author:

{u'username': u'kevinAlbs', u'name': u'Kevin Albertson', u'email': u'kevin.albertson@10gen.com'}

Message: SERVER-19097 Add version 3 to 2dsphere index
Branch: master
https://github.com/mongodb/mongo/commit/c33f68518b06e6b98596a8133d097e75d8431293

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