Page MenuHomeSoftware Heritage
Differential D2717

indexer.storage: Schema improvments
ClosedPublic
Actions

Authored by ardumont on Feb 25 2020, 5:24 PM.

Details

Reviewers
vlorentz
Group Reviewers
Reviewers
Commits
rDCIDX267cbc79d056: fossology_license: Improve add query endpoint
rDCIDX09cecc5a69fd: pgstorage: Empty temp tables instead of dropping them
Summary
  • Empty temp tables instead of dropping them (Similar to what we do in the swh.storage, D2580)
  • fossology_license: Improve add query endpoint (previously slow and unclear). This also aligns with other equivalent indexer functions do.
Test Plan

tox

Diff Detail

Repository
rDCIDX Metadata indexer
Branch
master
Lint
No Linters Available
Unit
No Unit Test Coverage
Build Status
Buildable 10765
Build 16162: tox-on-jenkinsJenkins
Build 16161: arc lint + arc unit

Event Timeline

ardumont created this revision.Feb 25 2020, 5:24 PM
swh-public-ci added a comment.Feb 25 2020, 5:30 PM

Build is green
See https://jenkins.softwareheritage.org/job/DCIDX/job/tox/694/ for more details.

Harbormaster completed remote builds in B10755: Diff 9689.Feb 25 2020, 5:30 PM
ardumont edited the summary of this revision. (Show Details)Feb 25 2020, 5:56 PM
ardumont edited the summary of this revision. (Show Details)Feb 26 2020, 10:56 AM
ardumont updated this revision to Diff 9699.Feb 27 2020, 10:36 AM

Plug and rebase on master

swh-public-ci added a comment.Feb 27 2020, 10:42 AM

Build is green
See https://jenkins.softwareheritage.org/job/DCIDX/job/tox/696/ for more details.

Harbormaster completed remote builds in B10765: Diff 9699.Feb 27 2020, 10:42 AM
This revision was not accepted when it landed; it landed in state Needs Review.Feb 27 2020, 10:46 AM
Closed by commit rDCIDX09cecc5a69fd: pgstorage: Empty temp tables instead of dropping them (authored by ardumont). · Explain Why
This revision was automatically updated to reflect the committed changes.
ardumont added a commit: rDCIDX09cecc5a69fd: pgstorage: Empty temp tables instead of dropping them.
ardumont added a commit: rDCIDX267cbc79d056: fossology_license: Improve add query endpoint.

Revision Contents
Changeset List

PathSize
sql/
upgrades/
119 lines
42 lines
swh/
indexer/
sql/
2 lines
53 lines

Diff 9699

View Options

sql/upgrades/129.sql

Loading...
View Options

sql/upgrades/130.sql

Loading...
View Options

swh/indexer/sql/30-swh-schema.sql

Loading...
View Options

swh/indexer/sql/40-swh-func.sql

Loading...
About · Developer information · Legal