pgsql: Teach planner to optionally ignore index columns that have an - Mailing list pgsql-committers

From tgl@svr1.postgresql.org (Tom Lane)
Subject pgsql: Teach planner to optionally ignore index columns that have an
Date
Msg-id 20050614040430.C888352871@svr1.postgresql.org
Whole thread Raw
List pgsql-committers
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 by date:

Previous
From: momjian@svr1.postgresql.org (Bruce Momjian)
Date:
Subject: pgsql: Done: > * -Use index to restrict rows returned by multi-key
Next
From: neilc@svr1.postgresql.org (Neil Conway)
Date:
Subject: pgsql: Allow the parameters to PL/PgSQL's RAISE statement to be