| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Nico Williams <nico(at)cryptonector(dot)com> |
| Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, Olleg Samoylov <splarv(at)ya(dot)ru>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Interesting case of IMMUTABLE significantly hurting performance |
| Date: | 2025-04-10 15:59:05 |
| Message-ID: | CAKFQuwa-H6ZzST_dFNhviqQ8b4fPfLT+o3btfygrVOxQJhgWNQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Apr 10, 2025 at 8:49 AM Nico Williams <nico(at)cryptonector(dot)com> 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.
>
>
Consulting pg_proc constitutes, IMO, going outside the documentation to
retrieve information. It is just not high up on anyone's annoyance list to
try and get this piece of information incorporated into the documentation.
Partly because \df+ does show this information as well, so at least one
doesn't have to go write the catalog query themself.
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2025-04-10 16:00:16 | Re: Interesting case of IMMUTABLE significantly hurting performance |
| Previous Message | Daniel Westermann (DWE) | 2025-04-10 15:48:40 | Re: Meson and Numa: C header not found |