Andrey Borodin <x4mmm(at)yandex-team(dot)ru> writes:
> I've tried to toy with the patch and remembered one related caveat.
> If we have index for both returnable and nonreturnable attributes, IOS will not be choosen:
> postgres=# create index on t using gist(a gist_trgm_ops) include (a);
> postgres=# explain select * from t where a like 'z';
> QUERY PLAN
> ---------------------------------------------------------------------
> Index Scan using t_a_a1_idx on t (cost=0.12..8.14 rows=1 width=32)
> Index Cond: (a ~~ 'z'::text)
> (2 rows)
This case is improved by 0002, no?
regards, tom lane