Re: Interesting case of IMMUTABLE significantly hurting performance

On 4/10/25 08:48, Nico Williams wrote:
> On Wed, Apr 09, 2025 at 02:43:11PM -0700, Adrian Klaver wrote:
>> On 4/9/25 14:21, Nico Williams wrote:
>>> That to_char is not immutable is not documented though. Though it's
>>> clear when looking at the docs for the `jsonb_.*_tz()` functions.
>>
>> From here:
>>
>> https://www.postgresql.org/docs/current/catalog-pg-proc.html
>>
>> select proname, provolatile, prosrc from pg_proc where proname='to_char';
>> [...]
>
> I'm surprised to see that counted as docs, but good to know.

When in doubt consult the system catalogs.

My guess is the absence of specific volatility information in the data
formatting functions is due to that information originating from a time
before provolatile existed. Whereas the jsonb_.*_tz() functions are
relatively new and where documented with knowledge of provolatile.

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com