pgsql: Teach btree to handle ScalarArrayOpExpr quals natively.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Teach btree to handle ScalarArrayOpExpr quals natively.
Date: 2011-10-16 19:39:59
Message-ID: E1RFWYx-0003BF-MP@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Teach btree to handle ScalarArrayOpExpr quals natively.

This allows "indexedcol op ANY(ARRAY[...])" conditions to be used in plain
indexscans, and particularly in index-only scans.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/9e8da0f75731aaa7605cf4656c21ea09e84d2eb1

Modified Files
--------------
doc/src/sgml/catalogs.sgml | 7 +
src/backend/access/nbtree/nbtree.c | 149 +++++++----
src/backend/access/nbtree/nbtutils.c | 457 ++++++++++++++++++++++++++++++++-
src/backend/executor/nodeIndexscan.c | 75 +++++-
src/backend/optimizer/path/costsize.c | 11 +-
src/backend/optimizer/path/indxpath.c | 49 +++--
src/backend/optimizer/util/plancat.c | 1 +
src/backend/utils/adt/selfuncs.c | 7 -
src/include/access/nbtree.h | 19 ++
src/include/access/skey.h | 23 ++-
src/include/catalog/catversion.h | 2 +-
src/include/catalog/pg_am.h | 50 ++--
src/include/nodes/relation.h | 3 +-
13 files changed, 725 insertions(+), 128 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2011-10-16 20:07:54 pgsql: Fix collate.linux.utf8 expected output for recent error message
Previous Message User Uwebartels 2011-10-16 14:04:13 pgstatspack - pgstatspack: install update for 2.3.1