Project

General

Profile

Actions

Story #10354

open

Add varchar_pattern_ops to all relevant PostgreSQL UUID indexes

Added by Tom Morris almost 6 years ago. Updated about 1 year ago.

Status:
New
Priority:
Normal
Assigned To:
Tom Morris
Category:
-
Target version:
-
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.

Actions

Also available in: Atom PDF