Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Missing indices on some columns used as foreign keys #17503

Open
bpedersen2 opened this issue Sep 6, 2022 · 0 comments
Open

Missing indices on some columns used as foreign keys #17503

bpedersen2 opened this issue Sep 6, 2022 · 0 comments
Assignees
@zyyw
Labels
kind/requirement New feature or idea on top of harbor

Comments

@bpedersen2
Copy link

Deleting the old scanner record was very slow, I needed to first add indexes on

registration_uuid for table vulnerability_record
report_uuid for table report_vulnerability_record

postgres recommends to alwaqys use an index on colums used in foreign keys.

Versions:

  • harbor version: [2.6.1]
@chlins chlins added the kind/requirement New feature or idea on top of harbor label Sep 19, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@zyyw zyyw

Labels
kind/requirement New feature or idea on top of harbor
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@bpedersen2 @zyyw @chlins