Re: function calls optimization

I think your first thought was good.
How high ? I think it's a matter of convention, certainly more than default
100.

czw., 21 lis 2019 o 02:05 Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com> napisał(a):

>
>
> On Thu, Oct 31, 2019 at 11:07 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
>>
>>
>> Possibly this could be finessed by only trying to find duplicates of
>> functions that have high cost estimates. Not sure how high is high
>> enough.
>
>
> can we just add a flag on pg_proc to show if the cost is high or not, if
> user are not happy with that, they can change it by updating the value?
> based on that most of the function call cost are low, this way may be
> helpful for the searching of duplicate expressions.
>