Re: function calls optimization - Mailing list pgsql-hackers

From Andy Fan
Subject Re: function calls optimization
Date
Msg-id CAKU4AWqmcGQiwSXbQ_zJTZrj+yH_LDqo+BSWYk_qbOQEnjFrZg@mail.gmail.com
Whole thread Raw
In response to Re: function calls optimization  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: function calls optimization  (Andrzej Barszcz <abusinf@gmail.com>)
List pgsql-hackers


On Thu, Oct 31, 2019 at 11:07 PM Tom Lane <tgl@sss.pgh.pa.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.

pgsql-hackers by date:

Previous
From: Andy Fan
Date:
Subject: Re: why doesn't optimizer can pull up where a > ( ... )
Next
From: Justin Pryzby
Date:
Subject: Re: checkpointer: PANIC: could not fsync file: No such file ordirectory