| From: | Chapman Flack <chap(at)anastigmatix(dot)net> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: is necessary to recheck cached data in fn_extra? |
| Date: | 2019-08-07 15:59:49 |
| Message-ID: | 5D4AF575.5000504@anastigmatix.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 08/07/19 11:39, Tom Lane wrote:
> Pavel Stehule <pavel(dot)stehule(at)gmail(dot)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.
It is going to be either the last thing I put there, or NULL, right?
So a null check is sufficient?
Other than when the SRF_* api has commandeered it for other purposes?
Regards,
-Chap
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2019-08-07 16:08:04 | Re: stress test for parallel workers |
| Previous Message | Alvaro Herrera | 2019-08-07 15:59:44 | Re: s/rewinded/rewound/? |