From: | Andrey Borodin <x4mmm(at)yandex-team(dot)ru> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-hackers(at)lists(dot)postgresql(dot)org |
Subject: | Re: Index-only scans vs. partially-retrievable indexes |
Date: | 2022-01-03 16:36:53 |
Message-ID: | 462641641227813@sas1-bf93f9015d57.qloud-c.yandex.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> 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?
>
Uhmm, yes, you are right. Works as expected with the second patch.
I tried first patch against this before writing. But did not expect much from a revert...
Thanks you!
Best regards, Andrey Borodin.
From | Date | Subject | |
---|---|---|---|
Next Message | Jacob Champion | 2022-01-03 16:46:16 | Re: [PoC] Delegating pg_ident to a third party |
Previous Message | Peter Eisentraut | 2022-01-03 16:35:31 | Re: psql - add SHOW_ALL_RESULTS option |