Skip site navigation (1) Skip section navigation (2)

Re: 'Index Full Scan' for Index Scan without Index Cond

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: 'Index Full Scan' for Index Scan without Index Cond
Date: 2006-06-06 14:02:19
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-patches
ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp> writes:
> Indexes are used for two purpose, for selection and for ordering, but EXPLAIN
> shows them as 'Index Scan' in both cases. This patch changes EXPLAIN output of
> Index Scan without Index Cond to 'Index Full Scan'.

This'll break existing tools that examine EXPLAIN output (eg, pgAdmin);
I don't really think it does enough for readability to justify that.
IMHO it'd be better to just add a paragraph to the documentation
pointing out what an indexscan without index condition means.

			regards, tom lane

In response to

pgsql-patches by date

Next:From: Simon RiggsDate: 2006-06-06 14:22:46
Subject: Why do we have a WAL record for CLOG page extension?
Previous:From: Jonah H. HarrisDate: 2006-06-06 13:54:43
Subject: Re: table/index fillfactor control

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group