Re: Function execution costs 'n all that

Neil Conway <neilc@samurai.com> writes:
> On Mon, 2007-01-15 at 15:05 -0500, Tom Lane wrote:
>> maybe we should just do the constant for starters and see how many
>> people really want to write C-code estimators ...

> +1

It seemed like that was the list's consensus, so I'll go off and do the
simple-constant case.  We can always extend it later.

For reference, the plan is to add these options to CREATE/ALTER
FUNCTION:
COST float-constant        (defaults to 1)ROWS float-constant        (defaults to 1000)

feeding into two float4 columns added to pg_proc.  ROWS is only
allowed/meaningful for set-returning functions.  COST is implicitly
scaled by cpu_operator_cost.
        regards, tom lane