RPM unit types have redundant search indices specified
Description of problem:
The RPM unit type JSON file specifies the first field of the unit key as a search index on multiple types. For example, RPM lists "name" as a search index and also as the first element of the unit key. This is redundant since the unit key causes a uniqueness constraint on the collection that effectively gives us a free "name" index. The harm in doing this is that MongoDB will use more RAM and will make writes slower since it has to update two indices needlessly.
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1. Look at /usr/lib/pulp/plugins/types/rpm_support.json
1. Use Mongo's shell to inspect the installed indices on the various unit collections.
There are redundant search indices.
There should not be any redundant search indices.
+ This bug was cloned from Bugzilla Bug #1169503 +
Updated by rbarlow almost 8 years ago
It may also be worth reconsidering all the fields we are indexing for searching while we fix this bug. For example, some of the units are indexing "arch", which will likely not be useful and will waste resources. The decision on what to index and what not to index can be tricky, but try to think about the balance of what would be useful to end users vs. how much RAM/write time each index costs.
+ This comment was cloned from Bugzilla #1169503 comment 1 +