Create a pg_trgm index on builds.drvpath

Dependencies

• [2] B7ENVLRS hydra-queue-runner: Make build notification more reliable
• [*] N22GPKYT * Put info about logs / build products in the DB.
• [*] D5QIOJGP * Move everything up one directory.

Change contents

• edit in src/sql/hydra.sql at line 691
  [2.1918]
  +

  + #ifdef POSTGRESQL

  + -- Provide an index used by LIKE operator on builds.drvpath (search query)

  + CREATE EXTENSION pg_trgm;

  + CREATE INDEX IndexTrgmBuildsOnDrvpath ON builds USING gin (drvpath gin_trgm_ops);

  + #endif
• file addition: upgrade-57.sql (----------)
  [5.3004]
  + CREATE EXTENSION pg_trgm;

  + CREATE INDEX IndexTrgmBuildsOnDrvpath ON builds USING gin (drvpath gin_trgm_ops);