]> granicus.if.org Git - postgresql/commit
projects / postgresql / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 788bce1) | patch
Add cost estimation of range @> and <@ operators.
authorHeikki Linnakangas <heikki.linnakangas@iki.fi>
Thu, 14 Mar 2013 13:36:56 +0000 (15:36 +0200)
committerHeikki Linnakangas <heikki.linnakangas@iki.fi>
Thu, 14 Mar 2013 13:36:56 +0000 (15:36 +0200)
commit59d0bf9dca58b237902c2fd1507e8bc5d54d4a63
tree0dd4fae4c70714395710a1817a0f23a37903a877tree | snapshot
parent788bce13d3249ddbcdf3443ee078145f4888ab45commit | diff
Add cost estimation of range @> and <@ operators.

The estimates are based on the existing lower bound histogram, and a new
histogram of range lengths.

Bump catversion, because the range length histogram now needs to be present
in statistic slot kind 6, or you get an error on @> and <@ queries. (A
re-ANALYZE would be enough to fix that, though)

Alexander Korotkov, with some refactoring by me.
src/backend/utils/adt/rangetypes_selfuncs.c diff | blob | history
src/backend/utils/adt/rangetypes_typanalyze.c diff | blob | history
src/include/catalog/catversion.h diff | blob | history
src/include/catalog/pg_operator.h diff | blob | history
src/include/catalog/pg_statistic.h diff | blob | history
Unnamed repository; edit this file 'description' to name the repository.