Comment 0 for bug 119780
Revision history for this message
| Stuart Bishop (stub) wrote GIN indexes cause some slow queries to fail entirely | #0 |
© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
2eb648a
demo site
(Get the code!)
On production:
launchpad_prod=# select person.id from person where person.fti @@ ftq('-lt');
ERROR: Query requires full scan, GIN doesn't support it
Seen in OOPS-524C471
We need to try reporting this upstream, because if the index is dropped, the query works - addition of an index should not block queries from working, as the index should not be involved at all if full table scan is needed.