Re: Interesting case of IMMUTABLE significantly hurting performance - Mailing list pgsql-general

From Merlin Moncure
Subject Re: Interesting case of IMMUTABLE significantly hurting performance
Date
Msg-id CAHyXU0wox32G2SteVou7VrBz1CHbDEcsGaTzgpLoyxGFHrN3YQ@mail.gmail.com
Whole thread Raw
In response to Re: Interesting case of IMMUTABLE significantly hurting performance  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: To take backup of Postgresql Database without large objects
Next
From: "David G. Johnston"
Date:
Subject: Re: Clarification on the docs