• Tom Lane's avatar
    Add COST and ROWS options to CREATE/ALTER FUNCTION, plus underlying pg_proc · 5a7471c3
    Tom Lane authored
    columns procost and prorows, to allow simple user adjustment of the estimated
    cost of a function call, as well as control of the estimated number of rows
    returned by a set-returning function.  We might eventually wish to extend this
    to allow function-specific estimation routines, but there seems to be
    consensus that we should try a simple constant estimate first.  In particular
    this provides a relatively simple way to control the order in which different
    WHERE clauses are applied in a plan node, which is a Good Thing in view of the
    fact that the recent EquivalenceClass planner rewrite made that much less
    predictable than before.
    5a7471c3
opr_sanity.out 36.2 KB