Re: Interesting case of IMMUTABLE significantly hurting performance
| От | David G. Johnston |
|---|---|
| Тема | Re: Interesting case of IMMUTABLE significantly hurting performance |
| Дата | |
| Msg-id | CAKFQuwa-H6ZzST_dFNhviqQ8b4fPfLT+o3btfygrVOxQJhgWNQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Interesting case of IMMUTABLE significantly hurting performance (Nico Williams <nico@cryptonector.com>) |
| Ответы |
Re: Interesting case of IMMUTABLE significantly hurting performance
|
| Список | pgsql-general |
On Thu, Apr 10, 2025 at 8:49 AM Nico Williams <nico@cryptonector.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.
В списке pgsql-general по дате отправления: