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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 'Index Full Scan' for Index Scan without Index Cond
Дата
Msg-id 15940.1149602539@sss.pgh.pa.us
обсуждение исходный текст
Ответ на 'Index Full Scan' for Index Scan without Index Cond  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
Список pgsql-patches
ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.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

В списке pgsql-patches по дате отправления:

Предыдущее
От: "Jonah H. Harris"
Дата:
Сообщение: Re: table/index fillfactor control
Следующее
От: Simon Riggs
Дата:
Сообщение: Why do we have a WAL record for CLOG page extension?