Re: [PERFORM] optimizing immutable vs. stable function calls?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [PERFORM] optimizing immutable vs. stable function calls?
Дата
Msg-id 16252.1484781941@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [PERFORM] optimizing immutable vs. stable function calls?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [PERFORM] optimizing immutable vs. stable function calls?
Список pgsql-performance
Karl Czajkowski <karlcz@isi.edu> writes:
> Is there a correctness hazard with pretending our function is
> IMMUTABLE, even though we will change the underlying config parameter
> in the same connection?

You could probably get away with that if you never ever use prepared
queries (beware that almost anything in plpgsql is a prepared query).
It's a trick that's likely to bite you eventually though.

            regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [PERFORM] optimizing immutable vs. stable function calls?
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: [PERFORM] optimizing immutable vs. stable function calls?