Merge lp:~wgrant/launchpad/dspc-trgm-indices into lp:launchpad
Proposed by
William Grant
Status: | Merged | ||||
---|---|---|---|---|---|
Approved by: | Stuart Bishop | ||||
Approved revision: | no longer in the source branch. | ||||
Merged at revision: | 15584 | ||||
Proposed branch: | lp:~wgrant/launchpad/dspc-trgm-indices | ||||
Merge into: | lp:launchpad | ||||
Diff against target: |
18 lines (+14/-0) 1 file modified
database/schema/patch-2209-23-0.sql (+14/-0) |
||||
To merge this branch: | bzr merge lp:~wgrant/launchpad/dspc-trgm-indices | ||||
Related bugs: |
|
Reviewer | Review Type | Date Requested | Status |
---|---|---|---|
Stuart Bishop (community) | db | Approve | |
Review via email: mp+109995@code.launchpad.net |
Commit message
Add indices to optimise the new version of Distribution.
Description of the change
This branch adds three indices to SourcePackagePu
The existing GiST FTI index is being replaced with a faster GIN one. name gets a trigram index so LIKE '%foo%' is fast. SPPH gets a new compound index.
To post a comment you must log in.
Applied to production