<!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 09:40, Achilleas Mantzios -
cloud wrote:<br>
</div>
<blockquote type="cite"
cite="mid:cca37a60-c11f-46ed-9e1f-2f783a042017@cloud.gatewaynet.com">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<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>
update the bug is in there no matter the patch's version, will keep
testing.<br>
<blockquote type="cite"
cite="mid:cca37a60-c11f-46ed-9e1f-2f783a042017@cloud.gatewaynet.com">
<p> </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/"
moz-do-not-send="true">http://www.sraoss.co.jp/index_en/</a>
<br>
Japanese:<a class="moz-txt-link-freetext"
href="http://www.sraoss.co.jp" moz-do-not-send="true">http://www.sraoss.co.jp</a>
<br>
</blockquote>
_______________________________________________ <br>
pgpool-general mailing list <br>
<a class="moz-txt-link-abbreviated moz-txt-link-freetext"
href="mailto:pgpool-general@pgpool.net" moz-do-not-send="true">pgpool-general@pgpool.net</a>
<br>
<a class="moz-txt-link-freetext"
href="http://www.pgpool.net/mailman/listinfo/pgpool-general"
moz-do-not-send="true">http://www.pgpool.net/mailman/listinfo/pgpool-general</a>
<br>
</blockquote>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre wrap="" class="moz-quote-pre">_______________________________________________
pgpool-general mailing list
<a class="moz-txt-link-abbreviated" href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a>
<a class="moz-txt-link-freetext" href="http://www.pgpool.net/mailman/listinfo/pgpool-general">http://www.pgpool.net/mailman/listinfo/pgpool-general</a>
</pre>
</blockquote>
</body>
</html>