public inbox for [email protected]  

help / color / mirror / Atom feed

From: Tom Lane <[email protected]>
To: Andrey Borodin <[email protected]>
Cc: [email protected]
Subject: Re: Index-only scans vs. partially-retrievable indexes
Date: Mon, 03 Jan 2022 09:57:14 -0500
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>

Andrey Borodin <[email protected]> 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

view thread (5+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Index-only scans vs. partially-retrievable indexes
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox