storage: Improve index on content_ctags
5e8bba58e8df
Actions

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

ardumont	Authored on Oct 20 2016, 3:53 PM
ardumont	Pushed on Oct 20 2016, 4:02 PM

Build Status

Buildable 543
Build 768: Software Heritage Python tests

Event Timeline

ardumont committed rDSTO5e8bba58e8df: storage: Improve index on content_ctags (authored by ardumont).Oct 20 2016, 3:55 PM

Harbormaster completed building B543: rDSTO5e8bba58e8df: storage: Improve index on content_ctags.Oct 20 2016, 4:03 PM

Commit No Longer Exists

This commit no longer exists in the repository.