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
simplify-schema
Lint
No Linters Available
Unit
No Unit Test Coverage
Build Status
Buildable 10755
Build 16147: tox-on-jenkinsJenkins
Build 16146: 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 9689

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