Project

General

Profile

Actions
Copy link

Idea #10354

open

Add varchar_pattern_ops to all relevant PostgreSQL UUID indexes

Added by Tom Morris over 7 years ago. Updated about 2 months ago.

Status:
New
Priority:
Normal
Assigned To:
Tom Morris
Category:
-
Target version:
Future
Start date:
Due date:
Story points:
-
Release:
Postponed
Release relationship:
Auto

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.

Actions
Copy link
 #1

Updated by Tom Morris over 7 years ago

  • Assigned To set to Radhika Chippada
Actions
Copy link
 #2

Updated by Radhika Chippada over 7 years ago

  • Target version deleted (2016-11-09 sprint)
Actions
Copy link
 #3

Updated by Tom Morris over 7 years ago

  • Assigned To changed from Radhika Chippada to Tom Morris
  • Target version set to Arvados Future Sprints
Actions
Copy link
 #4

Updated by Ward Vandewege almost 3 years ago

  • Target version deleted (Arvados Future Sprints)
Actions
Copy link
 #5

Updated by Peter Amstutz about 1 year ago

  • Release set to 60
Actions
Copy link
 #6

Updated by Peter Amstutz about 2 months ago

  • Target version set to Future
Actions
Copy link

Also available in: Atom PDF