Actions
Bug #22327
closed
container_request should have postgres index on (name, owner_uuid)
Status:
Resolved
Priority:
Normal
Assigned To:
Category:
API
Target version:
Story points:
-
Release:
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.
Updated by Peter Amstutz about 1 month ago
- Target version changed from Development 2024-12-04 to Development 2024-11-20
Updated by Peter Amstutz about 1 month ago
- Release set to 75
- Description updated (diff)
Updated by Peter Amstutz about 1 month ago
22327-container-request-index @ 45adf2a20fc1e9b2489ed6966efd7555fb821e02
Updated by Peter Amstutz about 1 month ago
- Status changed from New to In Progress
Updated by Tom Clegg about 1 month 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.
Updated by Peter Amstutz about 1 month ago
- Target version changed from Development 2024-11-20 to Development 2024-12-04
Updated by Peter Amstutz about 1 month ago
- Status changed from In Progress to Resolved
Actions