Story #10354
Add varchar_pattern_ops to all relevant PostgreSQL UUID indexes
Start date:
10/25/2016
Due date:
% Done:
0%
Estimated time:
Story points:
-
Description
Change all UUID varchar B-tree indexes so that they use varchar_pattern_ops so that we can do efficient prefix searches as described in
https://dev.arvados.org/issues/10028#note-11
Add a database migration to recreate the indexes and flag Ops that the migration needs to be run as part of the upgrade/deployment process.
History
#1
Updated by Tom Morris about 4 years ago
- Assigned To set to Radhika Chippada
#2
Updated by Radhika Chippada about 4 years ago
- Target version deleted (
2016-11-09 sprint)
#3
Updated by Tom Morris about 4 years ago
- Assigned To changed from Radhika Chippada to Tom Morris
- Target version set to Arvados Future Sprints