HomeSoftware Heritage

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

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
Parents
rDSCH0b04220c957b: Remove the creation of the 'load-deposit' task type
Branches
Unknown
Tags
Unknown
References
tag: v0.0.65
Build Status
Buildable 9744
Build 14369: test-and-buildJenkins