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

From: tgl(at)svr1(dot)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Teach planner to optionally ignore index columns that have an
Date: 2005-06-14 04:04:30
Message-ID: 20050614040430.C888352871@svr1.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

Browse pgsql-committers by date

  From Date Subject
Next Message Neil Conway 2005-06-14 06:43:15 pgsql: Allow the parameters to PL/PgSQL's RAISE statement to be
Previous Message Bruce Momjian 2005-06-14 03:20:11 pgsql: Done: > * -Use index to restrict rows returned by multi-key