Project

General

Profile

Actions

Bug #14008

closed

new index on containers locked_by_uuid

Added by Joshua Randall over 5 years ago. Updated over 5 years ago.

Status:
Resolved
Priority:
Normal
Assigned To:
Category:
API
Target version:
Story points:
-
Release:
Release relationship:
Auto

Description

We have added another custom query to our system to deal with slow container lookups (I think these are coming from crunch-dispatch-slurm, but apologies, I have not kept details of the exact queries or how slow they were).

The new index is:

create index index_containers_on_locked_by_uuid on containers (locked_by_uuid);


Subtasks 1 (0 open1 closed)

Task #14050: Review 14008-containers-indexResolvedPeter Amstutz08/20/2018Actions
Actions

Also available in: Atom PDF