Skip to content
Snippets Groups Projects
Select Git revision
  • benchmark-tools
  • postgres-lambda
  • master default
  • REL9_4_25
  • REL9_5_20
  • REL9_6_16
  • REL_10_11
  • REL_11_6
  • REL_12_1
  • REL_12_0
  • REL_12_RC1
  • REL_12_BETA4
  • REL9_4_24
  • REL9_5_19
  • REL9_6_15
  • REL_10_10
  • REL_11_5
  • REL_12_BETA3
  • REL9_4_23
  • REL9_5_18
  • REL9_6_14
  • REL_10_9
  • REL_11_4
23 results

alter_function.sgml

  • Tom Lane's avatar
    5a7471c3
    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
    History
    Add COST and ROWS options to CREATE/ALTER FUNCTION, plus underlying pg_proc
    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.