grahamc/hydra2 - Change TFVGX4JSTPHVTYUITKXWW2RKV27IEL3UQYXJFNDBPIBUU3XTZSDAC

Add an index to speed up the /project/<name> pages

Created by Eelco Dolstra on November 29, 2011

TFVGX4JSTPHVTYUITKXWW2RKV27IEL3UQYXJFNDBPIBUU3XTZSDAC

Dependencies

In channels

main

Change contents

Deletion in src/sql/hydra.sql at line 520 [5.1]
∅:D[3.56] → [4.2984:3104]
∅:D[6.258] → [4.2984:3104]
∅:D[7.1262] → [4.2984:3104]
∅:D[8.2384] → [4.2984:3104]
B:BD[4.2984] → [4.2984:3104]
```
create index IndexBuildResultInfo on BuildResultInfo(id); -- primary key index, not created automatically by PostgreSQL
```

Insertion in src/sql/hydra.sql at line 527 [5.1]

[8.2638]

[2.0]

create index IndexBuildsOnJobsetIsCurrent on Builds(project, jobset, isCurrent);