[pgpool-general: 9449] Re: Clarification on query results cache visibility
Tatsuo Ishii
ishii at postgresql.org
Wed Apr 30 15:48:01 JST 2025
>>> 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.
Best regards,
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp
-------------- next part --------------
A non-text attachment was scrubbed...
Name: query_cache-v2.patch
Type: text/x-patch
Size: 1356 bytes
Desc: not available
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20250430/6c4ada8e/attachment.bin>
More information about the pgpool-general
mailing list