IndexJobsetEvalsOnJobsetId: Only index jobsets with new builds
[?]
Jul 10, 2015, 1:23 PM
CHJANKMMK4CDR5FA36624JWTM25X2U66AM2PXBSH6C4W6KE6VZQACDependencies
- [2]
RXVJFQ5AEvaluator cleanups - [3]
YF3HTIPFUse 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
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;