Project

General

Profile

Actions
Copy link

Bug #22327

closed

container_request should have postgres index on (name, owner_uuid)

Added by Peter Amstutz 3 days ago. Updated about 12 hours ago.

Status:
Resolved
Priority:
Normal
Assigned To:
Peter Amstutz
Category:
API
Target version:
Development 2024-12-04
Story points:
-
Release:
Arvados 3.0.1
Release relationship:
Auto

Description

Without this index, a simple query for a container request with a specific name requires a full table scan.

On a large database a query on a container request name can take 10+ seconds.

Subtasks 1 (0 open — 1 closed)

Task #22329: Review 22327-container-request-indexResolvedPeter Amstutz11/20/2024Actions
Actions
Copy link
 #1

Updated by Peter Amstutz 3 days ago

  • Target version changed from Development 2024-12-04 to Development 2024-11-20
Actions
Copy link
 #2

Updated by Peter Amstutz 3 days ago

  • Release set to 75
  • Description updated (diff)
Actions
Copy link
 #4

Updated by Peter Amstutz 3 days ago

  • Description updated (diff)
Actions
Copy link
 #5

Updated by Peter Amstutz 3 days ago

  • Description updated (diff)
Actions
Copy link
 #6

Updated by Peter Amstutz 3 days ago

  • Status changed from New to In Progress
Actions
Copy link
 #7

Updated by Tom Clegg 3 days ago

Probably a good precaution to disable statement_timeout like we did for source:services/api/db/migrate/20240820202230_exclude_container_image_from_text_search.rb (see #22158)

    old_value = query_value('SHOW statement_timeout')
    execute "SET statement_timeout TO '0'" 
    ...
    execute "SET statement_timeout TO #{quote(old_value)}"

Rest LGTM.

Actions
Copy link
 #8

Updated by Peter Amstutz about 18 hours ago

  • Target version changed from Development 2024-11-20 to Development 2024-12-04
Actions
Copy link
 #9

Updated by Peter Amstutz about 12 hours ago

  • Status changed from In Progress to Resolved
Actions
Copy link

Also available in: Atom PDF