Re: function calls optimization

Поиск
Список
Период
Сортировка
От Andy Fan
Тема Re: function calls optimization
Дата
Msg-id CAKU4AWqmcGQiwSXbQ_zJTZrj+yH_LDqo+BSWYk_qbOQEnjFrZg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: function calls optimization  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: function calls optimization  (Andrzej Barszcz <abusinf@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Andy Fan
Дата:
Сообщение: Re: why doesn't optimizer can pull up where a > ( ... )
Следующее
От: Justin Pryzby
Дата:
Сообщение: Re: checkpointer: PANIC: could not fsync file: No such file ordirectory