I experimented with rewriting the query to use trigram indices for substring matching. The temp_* indices in https://pastebin.canonical.com/74853/ are new, https://pastebin.canonical.com/74853/ is a code diff to use them, and https://pastebin.canonical.com/74852/ is an example of the final query. It works fine (hundreds of milliseconds) for obscure strings like 'pcman', but strings with common trigrams like 'program' end up spending a couple of seconds in the GIN trigram indices. I suspect that proper FTI would be substantially faster.
-- You received this bug notification because you are a member of Ubuntu Translations Coordinators, which is subscribed to Ubuntu Translations. Matching subscriptions: Ubuntu Translations bug mail https://bugs.launchpad.net/bugs/869824 Title: Doing a search in the ddtp-ubuntu project's translations templates times out Status in Launchpad itself: Triaged Status in Ubuntu Translations: Triaged Bug description: Trying to search for a string to translate in the ddtp-ubuntu seems to always cause a timeout: https://translations.launchpad.net/ddtp-ubuntu/oneiric/+pots/ddtp- ubuntu-universe/ca/+translate?batch=10&show=all&search=modeller Here's one of the OOPSes I got: OOPS-2106CF25 To manage notifications about this bug go to: https://bugs.launchpad.net/launchpad/+bug/869824/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~ubuntu-translations-coordinators Post to : ubuntu-translations-coordinators@lists.launchpad.net Unsubscribe : https://launchpad.net/~ubuntu-translations-coordinators More help : https://help.launchpad.net/ListHelp