pgsql: Add index-only scan support to btree_gist. - Mailing list pgsql-committers

From Heikki Linnakangas
Subject pgsql: Add index-only scan support to btree_gist.
Date
Msg-id E1Ybby1-0001ni-0a@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Add index-only scan support to btree_gist.

inet, cidr, and timetz indexes still cannot support index-only scans,
because they don't store the original unmodified value in the index, but a
derived approximate value.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/e09b48316c22fce727bce3c89fa64fc627787e6a

Modified Files
--------------
contrib/btree_gist/Makefile                 |    3 +-
contrib/btree_gist/btree_cash.c             |    8 +
contrib/btree_gist/btree_date.c             |    7 +
contrib/btree_gist/btree_float4.c           |    8 +
contrib/btree_gist/btree_float8.c           |    8 +
contrib/btree_gist/btree_gist--1.0--1.1.sql |  127 +++
contrib/btree_gist/btree_gist--1.0.sql      | 1491 -------------------------
contrib/btree_gist/btree_gist--1.1.sql      | 1570 +++++++++++++++++++++++++++
contrib/btree_gist/btree_gist.control       |    2 +-
contrib/btree_gist/btree_int2.c             |    8 +
contrib/btree_gist/btree_int4.c             |    8 +
contrib/btree_gist/btree_int8.c             |    8 +
contrib/btree_gist/btree_interval.c         |    9 +
contrib/btree_gist/btree_macaddr.c          |    8 +
contrib/btree_gist/btree_oid.c              |    8 +
contrib/btree_gist/btree_time.c             |    8 +
contrib/btree_gist/btree_ts.c               |    8 +
contrib/btree_gist/btree_utils_num.c        |   58 +
contrib/btree_gist/btree_utils_num.h        |    1 +
contrib/btree_gist/btree_utils_var.c        |   18 +
contrib/btree_gist/expected/bit.out         |   10 +
contrib/btree_gist/expected/bytea.out       |   17 +
contrib/btree_gist/expected/cash.out        |    6 +-
contrib/btree_gist/expected/char.out        |   16 +
contrib/btree_gist/expected/char_1.out      |   16 +
contrib/btree_gist/expected/date.out        |    6 +-
contrib/btree_gist/expected/float4.out      |    6 +-
contrib/btree_gist/expected/float8.out      |    2 +-
contrib/btree_gist/expected/int2.out        |    6 +-
contrib/btree_gist/expected/int4.out        |    6 +-
contrib/btree_gist/expected/int8.out        |    2 +-
contrib/btree_gist/expected/interval.out    |    2 +-
contrib/btree_gist/expected/macaddr.out     |   23 +
contrib/btree_gist/expected/numeric.out     |   19 +
contrib/btree_gist/expected/text.out        |   16 +
contrib/btree_gist/expected/text_1.out      |   16 +
contrib/btree_gist/expected/time.out        |    2 +-
contrib/btree_gist/expected/timestamp.out   |    2 +-
contrib/btree_gist/expected/timestamptz.out |    2 +-
contrib/btree_gist/expected/varbit.out      |   10 +
contrib/btree_gist/sql/bit.sql              |    5 +
contrib/btree_gist/sql/bytea.sql            |    6 +
contrib/btree_gist/sql/char.sql             |    6 +
contrib/btree_gist/sql/macaddr.sql          |    6 +
contrib/btree_gist/sql/numeric.sql          |    6 +
contrib/btree_gist/sql/text.sql             |    6 +
contrib/btree_gist/sql/varbit.sql           |    5 +
47 files changed, 2077 insertions(+), 1514 deletions(-)


pgsql-committers by date:

Previous
From: Andrew Dunstan
Date:
Subject: pgsql: Fix portability issues with stddev in pg_stat_statements
Next
From: Tom Lane
Date:
Subject: Re: pgsql: Add stats for min, max, mean, stddev times to pg_stat_statements