pgsql: Teach planner to optionally ignore index columns that have an

Поиск
Список
Период
Сортировка
Искать
От
tgl@svr1.postgresql.org (Tom Lane)
Тема
pgsql: Teach planner to optionally ignore index columns that have an
Дата
Msg-id
20050614040430.C888352871@svr1.postgresql.org
Список
Log Message:
-----------
Teach planner to optionally ignore index columns that have an equality
constraint while determining whether the index sort order matches the
query's ORDER BY.  This for example allows an index on (x,y) to match
	... WHERE x = 42 ORDER BY y;
It only works for btree indexes, but since those are the only ones we
currently have that are ordered at all, that's good enough for now.
Per popular demand.

Modified Files:
--------------
    pgsql/src/backend/optimizer/path:
        indxpath.c (r1.184 -> r1.185)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/indxpath.c.diff?r1=1.184&r2=1.185)
В списке pgsql-committers по дате отправления
От: momjian@svr1.postgresql.org (Bruce Momjian)
Дата:
От: neilc@svr1.postgresql.org (Neil Conway)
Дата:
FAQ