Re: Text-any concatenation volatility acting as optimization barrier

Поиск
Список
Период
Сортировка
От Marti Raudsepp
Тема Re: Text-any concatenation volatility acting as optimization barrier
Дата
Msg-id CABRT9RB4-=ScOe00LN_N59b6Z84W0bz1Zc40Ccc93tyBKa7aKQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Text-any concatenation volatility acting as optimization barrier  (Andrew Dunstan <andrew@dunslane.net>)
Ответы Re: Text-any concatenation volatility acting as optimization barrier  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-hackers
Дерево обсуждения 
On Tue, Feb 7, 2012 at 22:31, Andrew Dunstan <andrew@dunslane.net> wrote:
> It gets worse if you replace the expression with a call to a (non-sql)
> function returning text, which was in fact the original use case. Then
> you're pretty  much hosed.

Oh, if it's a non-SQL function then marking it as STABLE/IMMUTABLE
should solve it -- did you try that?

Regards,
Marti

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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: Text-any concatenation volatility acting as optimization barrier
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: Text-any concatenation volatility acting as optimization barrier