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 Riggs||Date: 2006-06-06 14:22:46|
|Subject: Why do we have a WAL record for CLOG page extension?|
|Previous:||From: Jonah H. Harris||Date: 2006-06-06 13:54:43|
|Subject: Re: table/index fillfactor control|