diff options
| author | mkanat%bugzilla.org <> | 2008-03-25 04:47:21 +0100 |
|---|---|---|
| committer | mkanat%bugzilla.org <> | 2008-03-25 04:47:21 +0100 |
| commit | 2429c5daba37968dacb9b84e6eb671b057765fda (patch) | |
| tree | 5218a8c3da1a02d241d02c5b33572551cd98ce5e /Bugzilla/DB/Pg.pm | |
| parent | d7f129889f6d9eb839c18c6bf820f86ec57a2cfe (diff) | |
| download | bugzilla-2429c5daba37968dacb9b84e6eb671b057765fda.tar.gz bugzilla-2429c5daba37968dacb9b84e6eb671b057765fda.tar.xz | |
Bug 399370: Fulltext search with a LIKE on bugs.short_desc is too slow (make Bugzilla use a separate fulltext table)
Patch By Max Kanat-Alexander <mkanat@bugzilla.org> (module owner) a=mkanat
Diffstat (limited to 'Bugzilla/DB/Pg.pm')
| -rw-r--r-- | Bugzilla/DB/Pg.pm | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/Bugzilla/DB/Pg.pm b/Bugzilla/DB/Pg.pm index 9675e1f26..4777ba89a 100644 --- a/Bugzilla/DB/Pg.pm +++ b/Bugzilla/DB/Pg.pm @@ -179,6 +179,10 @@ sub bz_setup_database { # field, because it can't have index data longer than 2770 # characters on that field. $self->bz_drop_index('longdescs', 'longdescs_thetext_idx'); + # Same for all the comments fields in the fulltext table. + $self->bz_drop_index('bugs_fulltext', 'bugs_fulltext_comments_idx'); + $self->bz_drop_index('bugs_fulltext', + 'bugs_fulltext_comments_noprivate_idx'); # PostgreSQL also wants an index for calling LOWER on # login_name, which we do with sql_istrcmp all over the place. |