Page MenuHomeSoftware Heritage

Add an index for raw_extrinsic_metadata.id in swh.storage.postgresql
Open, HighPublic

Description

  1. new column with the hash
  2. fill it (will need a migration with python code)
  3. add unique index
  4. make the new index a primary key?

Related Objects

StatusAssignedTask
Resolvedardumont
OpenNone
ResolvedNone
OpenNone
Resolvedardumont
Work in Progressvlorentz
Work in Progressvlorentz
OpenNone
OpenNone
Work in Progressvlorentz
Work in Progressolasd
Openolasd
Resolvedvlorentz
Openvlorentz
Openvlorentz
Openvlorentz
Openvlorentz
Openvlorentz
OpenNone

Event Timeline

vlorentz triaged this task as High priority.Tue, Feb 2, 1:37 PM
vlorentz created this task.
vlorentz renamed this task from Allow querying raw_extrinsic_metadata by hash in swh.storage.postgresql to Add an index for raw_extrinsic_metadata.id in swh.storage.postgresql.Tue, Feb 2, 2:20 PM