Re: Interesting case of IMMUTABLE significantly hurting performance

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: Interesting case of IMMUTABLE significantly hurting performance
Дата
Msg-id CAHyXU0wox32G2SteVou7VrBz1CHbDEcsGaTzgpLoyxGFHrN3YQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Interesting case of IMMUTABLE significantly hurting performance  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Thu, Apr 10, 2025 at 10:51 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Merlin Moncure <mmoncure@gmail.com> writes:
> I guess the real problems here are lack of feedback on a number of fronts:
> *) the server knows the function is not immutable but lets you create it
> anyway, even though it can have negative downstream consequences

That's debatable I think.  If you know what you're doing, you're going
to be annoyed by warnings telling you that you don't.

> *) there is no way to discern inline vs non-inlined execution in explain

That's simply false.  Using the examples in this thread:

ah -- gotcha.  misread the original email --  should have known better :) 
thanks 

merlin

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