Project

Profile

Help

Maintenance. Planio will be undergoing a scheduled maintenance this weekend. Between Saturday, July 24 at 9:00 UTC and Sunday, July 25, 22:00 UTC your account might observe occasional downtimes which may last up to several minutes in some cases.

Task #8777

Evaluate need for index on content app's auto-distribute queries

Added by gerrod 2 months ago.

Status:
NEW
Priority:
Normal
Assignee:
-
Category:
-
Sprint/Milestone:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Platform Release:
Groomed:
No
Sprint Candidate:
No
Tags:
Sprint:
Quarter:

Description

Content app is now going to auto-distribute the latest publication it can find for a distribution's repository. https://github.com/pulp/pulpcore/pull/1328/ This feature requires a query for the latest repository version sorted by earliest pulp_created date. This query could potentially need an index in the future to remain performant.

Parent issue: https://pulp.plan.io/issues/8760

References for a multi-column index: https://devcenter.heroku.com/articles/postgresql-indexes#multi-column-indexes

Please register to edit this issue

Also available in: Atom PDF