Re: Suppressing unused subquery output columns

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Suppressing unused subquery output columns
Дата
Msg-id 1210.1402023256@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Suppressing unused subquery output columns  (Rod Taylor <rod.taylor@gmail.com>)
Ответы Re: Suppressing unused subquery output columns
Список pgsql-hackers
Rod Taylor <rod.taylor@gmail.com> writes:
> On Thu, Jun 5, 2014 at 10:27 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> I'm not entirely convinced that it's worth the extra planning cycles,
>> though.  Given the small number of complaints to date, it might not
>> be worth doing this.  Thoughts?

> Would this avoid execution of expensive functions in views when their
> output is discarded?

Yes, as long as they're not marked volatile and don't return sets.
        regards, tom lane



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

Предыдущее
От: Rod Taylor
Дата:
Сообщение: Re: Suppressing unused subquery output columns
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: B-Tree support function number 3 (strxfrm() optimization)