2008-12-08 11:27:22 |
Stuart Bishop |
bug |
|
|
added bug |
2008-12-08 11:32:41 |
Stuart Bishop |
bug |
|
|
assigned to postgresql |
2008-12-08 11:36:24 |
Stuart Bishop |
launchpad-foundations: status |
New |
Triaged |
|
2008-12-08 11:36:24 |
Stuart Bishop |
launchpad-foundations: importance |
Undecided |
Medium |
|
2008-12-08 11:36:24 |
Stuart Bishop |
launchpad-foundations: statusexplanation |
|
Launchpad can switch immediately to GIN indexes for a big speed improvement if this is fixed in PostgreSQL.
Launchpad ideally should detect if a query requires a full scan and abort the search gracefully. This would also be a work around to the edge case GIN doesn't support, and allow us to switch index types for a big speed improvement. This approach is discussed in Bug 119780. |
|
2011-10-01 21:00:44 |
Robert Collins |
launchpad: importance |
Medium |
High |
|
2011-10-01 21:00:49 |
Robert Collins |
postgresql: status |
New |
Fix Released |
|
2011-10-01 21:00:54 |
Robert Collins |
tags |
lp-foundations |
lp-foundations search |
|
2011-12-31 23:18:21 |
Robert Collins |
summary |
GIN indexes don't support full scans, causing queries to abort |
LP uses GIST indices which are slow to querty |
|
2011-12-31 23:18:27 |
Robert Collins |
summary |
LP uses GIST indices which are slow to querty |
LP uses GIST indices which are slow to query |
|
2011-12-31 23:18:38 |
Robert Collins |
tags |
lp-foundations search |
lp-foundations pg9 search |
|
2011-12-31 23:18:57 |
Robert Collins |
summary |
LP uses GIST indices which are slow to query |
LP uses GIST indices which are slow to query compared to GIN indices |
|
2012-05-31 09:58:07 |
Stuart Bishop |
branch linked |
|
lp:~stub/launchpad/db-cleanups |
|
2012-06-01 07:51:17 |
Launchpad QA Bot |
launchpad: assignee |
|
Stuart Bishop (stub) |
|
2012-06-01 07:51:18 |
Launchpad QA Bot |
tags |
lp-foundations pg9 search |
lp-foundations pg9 qa-needstesting search |
|
2012-06-01 07:51:20 |
Launchpad QA Bot |
launchpad: status |
Triaged |
In Progress |
|
2012-06-08 03:50:40 |
William Grant |
tags |
lp-foundations pg9 qa-needstesting search |
lp-foundations pg9 qa-ok search |
|
2012-06-09 02:02:24 |
Launchpad QA Bot |
tags |
lp-foundations pg9 qa-ok search |
lp-foundations pg9 qa-needstesting search |
|
2012-06-09 02:02:25 |
Launchpad QA Bot |
launchpad: status |
In Progress |
Fix Committed |
|
2012-06-14 01:29:44 |
William Grant |
tags |
lp-foundations pg9 qa-needstesting search |
lp-foundations pg9 qa-ok search |
|
2012-06-14 10:20:19 |
William Grant |
launchpad: status |
Fix Committed |
Fix Released |
|