diff options
| author | randomdan <randomdan@localhost> | 2011-03-31 14:10:26 +0000 |
|---|---|---|
| committer | randomdan <randomdan@localhost> | 2011-03-31 14:10:26 +0000 |
| commit | 66d3ef6d391f03f9eb977f8278d07528d68c33ca (patch) | |
| tree | 7a9218399de549fdfbdc5bc2226ebc6b1d2f9fcd | |
| parent | Show form submission errors in the form box (diff) | |
| download | gentoobrowse-66d3ef6d391f03f9eb977f8278d07528d68c33ca.tar.bz2 gentoobrowse-66d3ef6d391f03f9eb977f8278d07528d68c33ca.tar.xz gentoobrowse-66d3ef6d391f03f9eb977f8278d07528d68c33ca.zip | |
Use namedpackages function and GIN index to speed up bug association
| -rw-r--r-- | gentoobrowse/console/bugassociate.xml | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/gentoobrowse/console/bugassociate.xml b/gentoobrowse/console/bugassociate.xml index d18a98f..d8decc5 100644 --- a/gentoobrowse/console/bugassociate.xml +++ b/gentoobrowse/console/bugassociate.xml @@ -6,7 +6,7 @@ SELECT b.bugid, p.packageid FROM bugs b, packages p, categories c WHERE p.categoryid = c.categoryid - AND TO_TSVECTOR('english', REGEXP_REPLACE(b.summary, '-[0-9][^ ]*', '', 'g')) @@ PLAINTO_TSQUERY('english', c.name || '/' || p.name) + AND namedpackages(b.summary) @> ARRAY[c.name || '/' || p.name] </sql> <columns> <column key="true">bugid</column> |