Timeline for Subquery in where clause forces seq scan instead of using trigram index
Current License: CC BY-SA 4.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 22, 2019 at 13:00 | history | edited | Laurenz Albe | CC BY-SA 4.0 |
added 431 characters in body
|
| May 22, 2019 at 9:56 | comment | added | Mad Scientist | There is an index on datsets_id, and it looks like it's included in the bitmap index scan when the values are hardcoded, but not if there is a subquery. | |
| May 22, 2019 at 8:39 | history | answered | Laurenz Albe | CC BY-SA 4.0 |