HomeSoftware Heritage

Add an indexed `revision_date` column on the `content_in_revision` relation

Description

Add an indexed revision_date column on the content_in_revision relation

This allows answering the earliest occurrence question in a single query
instead of having to go through a join of the revision table.

Details

Provenance
olasdAuthored on Nov 29 2022, 4:08 PM
olasdPushed on Nov 29 2022, 4:28 PM
Parents
rDPROVc46d896cd651: Drop denormalized db flavor
Branches
Unknown
Tags
Unknown
References
HEAD -> master
Build Status
Buildable 33026
Build 51759: test-and-buildJenkins console · Jenkins