Re: is necessary to recheck cached data in fn_extra?

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: is necessary to recheck cached data in fn_extra?
Дата
Msg-id CAFj8pRAPpT29i3W-pXv4P-1sTMqGZtkubqKhiAey80+0pqu2mA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: is necessary to recheck cached data in fn_extra?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: is necessary to recheck cached data in fn_extra?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers


st 7. 8. 2019 v 17:39 odesílatel Tom Lane <tgl@sss.pgh.pa.us> napsal:
Pavel Stehule <pavel.stehule@gmail.com> writes:
> I should to use a cache accessed via fn_extra. There will be stored data
> about function parameters (types). If I understand correctly, these data
> should be stable in query, and then recheck is not necessary. Is it true?

I wouldn't trust that.  You don't really know what the lifespan of
a fn_extra cache is.

fn_extra cache cannot be longer than query. And if I understand well, then is not possible to change parameter types inside query?

Pavel


                        regards, tom lane

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

Предыдущее
От: Geoff Winkless
Дата:
Сообщение: Re: s/rewinded/rewound/?
Следующее
От: Konstantin Knizhnik
Дата:
Сообщение: Re: Removing unneeded self joins