<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p><br>
</p>
<div class="moz-cite-prefix">On 4/30/25 08:12, Achilleas Mantzios -
cloud wrote:<br>
</div>
<blockquote type="cite"
cite="mid:18b14455-23ff-4de8-82d6-8d0c94e56fe1@cloud.gatewaynet.com">On
4/30/25 07:48, Tatsuo Ishii wrote:
<br>
<br>
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">Thank you a lot for such a quick
response ! I applied, and re-run the
<br>
test, it works correctly.
<br>
<br>
We will keep testing as in live conditions, with wildfly ,
etc.
<br>
</blockquote>
</blockquote>
</blockquote>
I have updated the patch. In the previous patch, information on
<br>
whether the query is "cache safe", which means it is safe to
cache the
<br>
result of the query, is checked on the global state. Attached
patch
<br>
instead checks it directly on the information contained in the
bind
<br>
message data, which is an argument of the function responsible
for
<br>
processing execute messages. In most cases the global state is
synced
<br>
with the bind state, but obtaining information from the bind
message
<br>
is safer.
<br>
</blockquote>
<br>
Ok, I applied and restarted, thank you!
<br>
<br>
Now the cache seems very robust, and fast.
<br>
</blockquote>
<p>Unfortunately the 2nd patch (<span style="font-family:monospace"><span
style="color:#000000;background-color:#ffffff;">query_cache-v2.patch</span></span>)
broke something. Cannot figure yet.</p>
<p>Reverting to the previous patch (yesterday) : <span
style="font-family:monospace"><span
style="color:#000000;background-color:#ffffff;">query_cache.patch</span>
</span>Rev, seems to work correctly.</p>
<p>The scenario involved arrays (pgsql int[] ). (and intarray
extension). I dont know if I am able to do anything (debug) today,
due to immense work load.<br>
</p>
<blockquote type="cite"
cite="mid:18b14455-23ff-4de8-82d6-8d0c94e56fe1@cloud.gatewaynet.com">
<br>
<blockquote type="cite">
<br>
Best regards,
<br>
--
<br>
Tatsuo Ishii
<br>
SRA OSS K.K.
<br>
English: <a class="moz-txt-link-freetext" href="http://www.sraoss.co.jp/index_en/">http://www.sraoss.co.jp/index_en/</a>
<br>
Japanese:<a class="moz-txt-link-freetext" href="http://www.sraoss.co.jp">http://www.sraoss.co.jp</a>
<br>
</blockquote>
_______________________________________________
<br>
pgpool-general mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a>
<br>
<a class="moz-txt-link-freetext" href="http://www.pgpool.net/mailman/listinfo/pgpool-general">http://www.pgpool.net/mailman/listinfo/pgpool-general</a>
<br>
</blockquote>
</body>
</html>