They should be a rare occurence, so adding these indices allows us to count
and enumerate them without expensive full table scans.
Details
Details
- Reviewers
olasd ardumont - Group Reviewers
Reviewers - Commits
- rDSTOc68a4fd98fb4: postgres: Add indices to keep track of objects with a raw_manifest
Diff Detail
Diff Detail
- Repository
- rDSTO Storage manager
- Lint
Automatic diff as part of commit; lint not applicable. - Unit
Automatic diff as part of commit; unit tests not applicable.
Event Timeline
Comment Actions
Build has FAILED
Patch application report for D6958 (id=25213)
Rebasing onto 40a57d4351...
Current branch diff-target is up to date.
Changes applied before test
commit 8d5055eac54771d65e887455fe7ab2a66b96a445
Author: Valentin Lorentz <vlorentz@softwareheritage.org>
Date: Mon Jan 17 16:59:37 2022 +0100
postgres: Add indices to keep track of objects with a raw_manifest
They should be a rare occurence, so adding these indices allows us to count
and enumerate them without expensive full table scans.Link to build: https://jenkins.softwareheritage.org/job/DSTO/job/tests-on-diff/1527/
See console output for more information: https://jenkins.softwareheritage.org/job/DSTO/job/tests-on-diff/1527/console
Comment Actions
Build has FAILED
Patch application report for D6958 (id=25214)
Rebasing onto 40a57d4351...
Current branch diff-target is up to date.
Changes applied before test
commit 25ad2a490e46bab4f9d534befe49c296bac18599
Author: Valentin Lorentz <vlorentz@softwareheritage.org>
Date: Mon Jan 17 16:59:37 2022 +0100
postgres: Add indices to keep track of objects with a raw_manifest
They should be a rare occurence, so adding these indices allows us to count
and enumerate them without expensive full table scans.Link to build: https://jenkins.softwareheritage.org/job/DSTO/job/tests-on-diff/1528/
See console output for more information: https://jenkins.softwareheritage.org/job/DSTO/job/tests-on-diff/1528/console
Comment Actions
Build has FAILED
Link to build: https://jenkins.softwareheritage.org/job/DSTO/job/tests-on-diff/1530/
See console output for more information: https://jenkins.softwareheritage.org/job/DSTO/job/tests-on-diff/1530/console
Comment Actions
Build is green
Patch application report for D6958 (id=25220)
Rebasing onto 228de33736...
Current branch diff-target is up to date.
Changes applied before test
commit 34ddbd3ccd748fb199a2a4d26bb114114001d9c6
Author: Valentin Lorentz <vlorentz@softwareheritage.org>
Date: Mon Jan 17 16:59:37 2022 +0100
postgres: Add indices to keep track of objects with a raw_manifest
They should be a rare occurence, so adding these indices allows us to count
and enumerate them without expensive full table scans.See https://jenkins.softwareheritage.org/job/DSTO/job/tests-on-diff/1531/ for more details.
Comment Actions
Sounds good. I don't think we need to make them unique though (and it might make stuff confusing if writes get rejected by this index rather than the primary one)
Comment Actions
Build is green
Patch application report for D6958 (id=25236)
Rebasing onto 228de33736...
Current branch diff-target is up to date.
Changes applied before test
commit c68a4fd98fb4025b67b093053d96d23a7a6937cb
Author: Valentin Lorentz <vlorentz@softwareheritage.org>
Date: Mon Jan 17 16:59:37 2022 +0100
postgres: Add indices to keep track of objects with a raw_manifest
They should be a rare occurence, so adding these indices allows us to count
and enumerate them without expensive full table scans.See https://jenkins.softwareheritage.org/job/DSTO/job/tests-on-diff/1532/ for more details.