HomeSoftware Heritage

Use a btree of (task_type, md5(arguments)) to match task arguments

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

Description

Use a btree of (task_type, md5(arguments)) to match task arguments

The former index on hash(arguments->'args') has lost relevance as about half the
tasks (the ones for the loader) have the same value (an empty list) for this
field.

This index is more universal, faster, and also easier to convince the planner of
using.

If we want more specific indexes (e.g. on specific keyword arguments) we'll be
able to add that separately.

Details

Provenance
olasdAuthored on Dec 13 2019, 11:29 AM
olasdPushed on Dec 13 2019, 11:43 AM
Differential Revision
D2448: Use a btree of (task_type, md5(arguments)) to match task arguments
Build Status
Buildable 9744
Build 14369: test-and-buildJenkins

Commit No Longer Exists

This commit no longer exists in the repository.