HomeSoftware Heritage

storage.db: Improve content range queries to actually finish

This commit no longer exists in the repository. It may have been part of a branch which was deleted.

Description

storage.db: Improve content range queries to actually finish

In production, the previous query version takes too long to finish. This ended
up with timeouts (with query still running in the pg backend). Accumulating
similar new queries.

Counter-intuitively, specifying twice the range query to use (both in
content_mimetype and content_fossology_license), the execution now returns
immediately.

Close T1788

Details

Provenance
ardumontAuthored on Feb 24 2020, 12:14 PM
ardumontPushed on Feb 25 2020, 11:28 AM
Differential Revision
D2709: idx.storage.db: Improve content range queries to actually finish
Tasks
T1788: indexer-license: Investigate timeouts
Build Status
Buildable 10747
Build 16134: test-and-buildJenkins

Commit No Longer Exists

This commit no longer exists in the repository.