]> granicus.if.org Git - postgresql/commit
Build out the planner support function infrastructure.
authorTom Lane <tgl@sss.pgh.pa.us>
Sat, 9 Feb 2019 23:32:23 +0000 (18:32 -0500)
committerTom Lane <tgl@sss.pgh.pa.us>
Sat, 9 Feb 2019 23:32:23 +0000 (18:32 -0500)
commita391ff3c3d418e404a2c6e4ff0865a107752827b
treef076c5785d06e7ccf082b08c1651b17d95af4563
parent1fb57af92069ee104c09e2016af9e0e620681be3
Build out the planner support function infrastructure.

Add support function requests for estimating the selectivity, cost,
and number of result rows (if a SRF) of the target function.

The lack of a way to estimate selectivity of a boolean-returning
function in WHERE has been a recognized deficiency of the planner
since Berkeley days.  This commit finally fixes it.

In addition, non-constant estimates of cost and number of output
rows are now possible.  We still fall back to looking at procost
and prorows if the support function doesn't service the request,
of course.

To make concrete use of the possibility of estimating output rowcount
for SRFs, this commit adds support functions for array_unnest(anyarray)
and the integer variants of generate_series; the lack of plausible
rowcount estimates for those, even when it's obvious to a human,
has been a repeated subject of complaints.  Obviously, much more
could now be done in this line, but I'm mostly just trying to get
the infrastructure in place.

Discussion: https://postgr.es/m/15193.1548028093@sss.pgh.pa.us
27 files changed:
contrib/postgres_fdw/postgres_fdw.c
doc/src/sgml/xfunc.sgml
src/backend/optimizer/path/clausesel.c
src/backend/optimizer/path/costsize.c
src/backend/optimizer/util/clauses.c
src/backend/optimizer/util/pathnode.c
src/backend/optimizer/util/plancat.c
src/backend/utils/adt/arrayfuncs.c
src/backend/utils/adt/int.c
src/backend/utils/adt/int8.c
src/backend/utils/adt/selfuncs.c
src/backend/utils/cache/lsyscache.c
src/include/catalog/catversion.h
src/include/catalog/pg_proc.dat
src/include/nodes/nodes.h
src/include/nodes/pathnodes.h
src/include/nodes/supportnodes.h
src/include/optimizer/clauses.h
src/include/optimizer/plancat.h
src/include/utils/lsyscache.h
src/test/regress/expected/misc_functions.out
src/test/regress/expected/subselect.out
src/test/regress/input/create_function_1.source
src/test/regress/output/create_function_1.source
src/test/regress/regress.c
src/test/regress/sql/misc_functions.sql
src/test/regress/sql/subselect.sql