From: | Heikki Linnakangas <heikki(dot)linnakangas(at)iki(dot)fi> |
---|---|
To: | pgsql-committers(at)postgresql(dot)org |
Subject: | pgsql: Add index-only scan support to btree_gist. |
Date: | 2015-03-27 21:39:01 |
Message-ID: | E1Ybby1-0001ni-0a@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2015-03-27 21:53:21 | Re: pgsql: Add stats for min, max, mean, stddev times to pg_stat_statements |
Previous Message | Andrew Dunstan | 2015-03-27 21:33:46 | pgsql: Fix portability issues with stddev in pg_stat_statements |