Horton

Add index-only scan support to btree_gist.

Heikki Linnakangas <heikki.linnakangas@iki.fi>

View on postgr.es
Commit: e09b48316c22fce727bce3c89fa64fc627787e6a
Author: Heikki Linnakangas <heikki.linnakangas@iki.fi>
Date: 2015-03-27T21:35:16Z
Releases: 9.5.0 
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.

Files

PathChange+/−
contrib/btree_gist/btree_cash.c modified +8 −0
contrib/btree_gist/btree_date.c modified +7 −0
contrib/btree_gist/btree_float4.c modified +8 −0
contrib/btree_gist/btree_float8.c modified +8 −0
contrib/btree_gist/btree_gist--1.0--1.1.sql added +127 −0
contrib/btree_gist/btree_gist--1.1.sql (from contrib/btree_gist/btree_gist--1.0.sql) renamed +107 −28
contrib/btree_gist/btree_gist.control modified +1 −1
contrib/btree_gist/btree_int2.c modified +8 −0
contrib/btree_gist/btree_int4.c modified +8 −0
contrib/btree_gist/btree_int8.c modified +8 −0
contrib/btree_gist/btree_interval.c modified +9 −0
contrib/btree_gist/btree_macaddr.c modified +8 −0
contrib/btree_gist/btree_oid.c modified +8 −0
contrib/btree_gist/btree_time.c modified +8 −0
contrib/btree_gist/btree_ts.c modified +8 −0
contrib/btree_gist/btree_utils_num.c modified +58 −0
contrib/btree_gist/btree_utils_num.h modified +1 −0
contrib/btree_gist/btree_utils_var.c modified +18 −0
contrib/btree_gist/expected/bit.out modified +10 −0
contrib/btree_gist/expected/bytea.out modified +17 −0
contrib/btree_gist/expected/cash.out modified +3 −3
contrib/btree_gist/expected/char_1.out modified +16 −0
contrib/btree_gist/expected/char.out modified +16 −0
contrib/btree_gist/expected/date.out modified +3 −3
contrib/btree_gist/expected/float4.out modified +3 −3
contrib/btree_gist/expected/float8.out modified +1 −1
contrib/btree_gist/expected/int2.out modified +3 −3
contrib/btree_gist/expected/int4.out modified +3 −3
contrib/btree_gist/expected/int8.out modified +1 −1
contrib/btree_gist/expected/interval.out modified +1 −1
contrib/btree_gist/expected/macaddr.out modified +23 −0
contrib/btree_gist/expected/numeric.out modified +19 −0
contrib/btree_gist/expected/text_1.out modified +16 −0
contrib/btree_gist/expected/text.out modified +16 −0
contrib/btree_gist/expected/time.out modified +1 −1
contrib/btree_gist/expected/timestamp.out modified +1 −1
contrib/btree_gist/expected/timestamptz.out modified +1 −1
contrib/btree_gist/expected/varbit.out modified +10 −0
contrib/btree_gist/Makefile modified +2 −1
contrib/btree_gist/sql/bit.sql modified +5 −0
contrib/btree_gist/sql/bytea.sql modified +6 −0
contrib/btree_gist/sql/char.sql modified +6 −0
contrib/btree_gist/sql/macaddr.sql modified +6 −0
contrib/btree_gist/sql/numeric.sql modified +6 −0
contrib/btree_gist/sql/text.sql modified +6 −0
contrib/btree_gist/sql/varbit.sql modified +5 −0