Staging instance, all changes can be removed at any time

Skip to content

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

Nicolas Dandrimont requested to merge generated-differential-D2448-source into generated-differential-D2448-target

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.

Test Plan

this is deployed in production (which is the best way to have a relevant, large dataset to check these kinds of queries...)

Migrated from D2448 (view on Phabricator)

Merge request reports