<div dir="ltr">Thanks!</div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, May 18, 2017 at 4:04 PM, Tatsuo Ishii <span dir="ltr"><<a href="mailto:ishii@sraoss.co.jp" target="_blank">ishii@sraoss.co.jp</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Sounds reasonable request. Implementing the feature is not trivial<br>
however. Problem is, when the cache is about to reset, there may be<br>
concurrent sessions which are already accessing the cache in the<br>
shared memory. For example, a session is returning query results from<br>
cache. Another sesson is just registering a new cache entry. I have<br>
added this our TODO.<br>
<br>
<a href="http://pgpool.net/mediawiki/index.php/TODO#Allow_to_reset_in_memory_query_cache_in_the_shared_memory_without_restarting_Pgpool-II" rel="noreferrer" target="_blank">http://pgpool.net/mediawiki/<wbr>index.php/TODO#Allow_to_reset_<wbr>in_memory_query_cache_in_the_<wbr>shared_memory_without_<wbr>restarting_Pgpool-II</a><br>
<div class="HOEnZb"><div class="h5"><br>
Best regards,<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" rel="noreferrer" target="_blank">http://www.sraoss.co.jp/index_<wbr>en.php</a><br>
Japanese:<a href="http://www.sraoss.co.jp" rel="noreferrer" target="_blank">http://www.sraoss.co.<wbr>jp</a><br>
<br>
> We host several applications on the same DB. Sometimes folks apply<br>
> patches/update to some databases by directly connecting to the DB instead<br>
> of through pgpool. To fix the problem, I have to restart the service which<br>
> brings down all the applications connected to the pgpool service. These<br>
> applications now have to create brand new DB connections to continue<br>
> working which is pretty drastic.<br>
><br>
> Having an option to reset cache in such a scenario without bringing the<br>
> service down is convenient. Then I just have to take a performance hit<br>
> till the cache warms up again.<br>
> -AJ<br>
><br>
> On Thu, May 18, 2017 at 3:16 PM, Tatsuo Ishii <<a href="mailto:ishii@sraoss.co.jp">ishii@sraoss.co.jp</a>> wrote:<br>
><br>
>> > Is there a way to reset the entire cache without restarting the pgpool<br>
>> > service using SQL when using shmem?<br>
>><br>
>> No. Sorry. Why do you need it?<br>
>><br>
>> Best regards,<br>
>> --<br>
>> Tatsuo Ishii<br>
>> SRA OSS, Inc. Japan<br>
>> English: <a href="http://www.sraoss.co.jp/index_en.php" rel="noreferrer" target="_blank">http://www.sraoss.co.jp/index_<wbr>en.php</a><br>
>> Japanese:<a href="http://www.sraoss.co.jp" rel="noreferrer" target="_blank">http://www.sraoss.co.<wbr>jp</a><br>
>><br>
</div></div></blockquote></div><br></div>