Re: function(contants) evaluated for every row

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: function(contants) evaluated for every row
Дата
Msg-id 18279.1290629954@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: function(contants) evaluated for every row  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
Bruce Momjian <bruce@momjian.us> writes:
> I realize they can't be converted to constants before the query starts
> but is there a reason we can't convert those functions to constants in
> the executor before a table scan?

Other than the significant number of cycles that would be wasted (in
most cases) checking for the possibility, probably not.  I'm dubious
that it would average out to a win though.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: profiling connection overhead
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Per-column collation