IndexJobsetEvalsOnJobsetId: Only index jobsets with new builds

[?]
Jul 10, 2015, 1:23 PM
CHJANKMMK4CDR5FA36624JWTM25X2U66AM2PXBSH6C4W6KE6VZQAC

Dependencies

  • [2] RXVJFQ5A Evaluator cleanups
  • [3] YF3HTIPF Use partial indexes
  • [*] N22GPKYT * Put info about logs / build products in the DB.
  • [*] D5QIOJGP * Move everything up one directory.

Change contents

  • replacement in src/sql/hydra.sql at line 626
    [2.3383][2.3383:3479]()
    create index IndexJobsetEvalsOnJobsetId on JobsetEvals(project, jobset, hasNewBuilds, id desc);
    [2.3383]
    create index IndexJobsetEvalsOnJobsetId on JobsetEvals(project, jobset, id desc) where hasNewBuilds = 1;
  • file addition: upgrade-38.sql (----------)
    [6.3004]
    drop index IndexJobsetEvalsOnJobsetId;
    create index IndexJobsetEvalsOnJobsetId on JobsetEvals(project, jobset, id desc) where hasNewBuilds = 1;