[pgpool-general: 9450] Re: Clarification on query results cache visibility

[Achilleas Mantzios - cloud]

On 4/30/25 07:48, Tatsuo Ishii wrote:

>>>> Thank you a lot for such a quick response ! I applied, and re-run the
>>>> test, it works correctly.
>>>>
>>>> We will keep testing as in live conditions, with wildfly , etc.
> I have updated the patch. In the previous patch, information on
> whether the query is "cache safe", which means it is safe to cache the
> result of the query, is checked on the global state. Attached patch
> instead checks it directly on the information contained in the bind
> message data, which is an argument of the function responsible for
> processing execute messages. In most cases the global state is synced
> with the bind state, but obtaining information from the bind message
> is safer.

Ok, I applied and restarted, thank you!

Now the cache seems very robust, and fast.

>
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS K.K.
> English: http://www.sraoss.co.jp/index_en/
> Japanese:http://www.sraoss.co.jp