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
Lint
Automatic diff as part of commit; lint not applicable.
Unit
Automatic diff as part of commit; unit tests not applicable.

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
swh/
indexer/
sql/
2 lines
38 lines

Diff 9700

View Options

sql/upgrades/129.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