'untranslated' filter slow with message sharing
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Launchpad itself |
Fix Released
|
High
|
Данило Шеган |
Bug Description
Postgres chooses a bad query plan with existing 'untranslated' filter.
A fix means several things:
* replace "POTMsgSet.id IN" with "TranslationTem
* add TranslationTemp
Basically, the second change makes Postgres use translationtemp
These two changes combined give us around 40x improvement, so on our biggest POTemplate (i.e. ddtp-universe package descriptions, with 45000 messages) we get queries in 550ms where we had 21s.
Changed in rosetta: | |
assignee: | nobody → Данило Шеган (danilo) |
milestone: | none → 2.2.4 |
Changed in rosetta: | |
importance: | Undecided → High |
status: | New → In Progress |
description: | updated |
description: | updated |
description: | updated |
description: | updated |
Changed in rosetta: | |
status: | Fix Committed → Fix Released |
Sample 'untranslated' filter timeout: https:/ /lp-oops. canonical. com/oops. py/?oopsid= OOPS-1199S2025