On Sat, Aug 07, 2021 at 07:35:25PM +, Alex wrote:
> Table "product" has a GIN index on "lexeme" column (tsvector) that is not
> used.
>
> Query that doesn't use lexeme idx: https://explain.dalibo.com/plan/BlB#plan,
> ~8s, ~60.000 blocks needed
>
> Query forced to use lexeme idx: https://ex
Table "product" has a GIN index on "lexeme" column (tsvector) that is not used.
Query that doesn't use lexeme idx: https://explain.dalibo.com/plan/BlB#plan,
~8s, ~60.000 blocks needed
Query forced to use lexeme idx: https://explain.dalibo.com/plan/i52, ~800ms
(10x less), ~15.000 blocks needed
