Horton

Fix BRIN cost estimation

Alvaro Herrera <alvherre@alvh.no-ip.org>

View on postgr.es
Commit: 7e534adcdc70866e7be74d626b0ed067c890a251
Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
Date: 2017-04-06T20:51:53Z
Releases: 10.0 
Fix BRIN cost estimation

The original code was overly optimistic about the cost of scanning a
BRIN index, leading to BRIN indexes being selected when they'd be a
worse choice than some other index.  This complete rewrite should be
more accurate.

Author: David Rowley, based on an earlier patch by Emre Hasegeli
Reviewed-by: Emre Hasegeli
Discussion: https://postgr.es/m/CAKJS1f9n-Wapop5Xz1dtGdpdqmzeGqQK4sV2MK-zZugfC14Xtw@mail.gmail.com

Files

PathChange+/−
src/backend/access/brin/brin.c modified +21 −0
src/backend/utils/adt/selfuncs.c modified +171 −26
src/include/access/brin.h modified +14 −0
src/test/regress/expected/brin.out modified +26 −0
src/test/regress/sql/brin.sql modified +16 −0

Discussion