HomeSoftware Heritage

storage: Improve index on content_ctags

Description

storage: Improve index on content_ctags

Work on the suggestion message from postgresql

psycopg2.OperationalError: index row size 3992 exceeds maximum 2712 for
index "content_ctags_id_name_kind_line_lang_idx" HINT: Values larger
than 1/3 of a buffer page cannot be indexed. Consider a function index
of an MD5 hash of the value, or use full text indexing.

Related T589

Details

Provenance
ardumontAuthored on Oct 20 2016, 3:53 PM
ardumontPushed on Oct 20 2016, 4:02 PM
Parents
rDSTO33043b131758: storage: ctags - Improve schema
Branches
Unknown
Tags
Unknown
References
tag: v0.0.69
Build Status
Buildable 543
Build 768: Software Heritage Python tests