Comment 1 for bug 306201
Revision history for this message
| Stuart Bishop (stub) wrote Re: GIN indexes don't support full scans, causing queries to abort | #1 |
© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
7020100
(Get the code!)
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.