[pgpool-general: 5510] Re: Resetting Pgpool cache
ankur.jain at obeohealth.com
Fri May 19 08:27:35 JST 2017
On Thu, May 18, 2017 at 4:04 PM, Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
> Sounds reasonable request. Implementing the feature is not trivial
> however. Problem is, when the cache is about to reset, there may be
> concurrent sessions which are already accessing the cache in the
> shared memory. For example, a session is returning query results from
> cache. Another sesson is just registering a new cache entry. I have
> added this our TODO.
> Best regards,
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> > We host several applications on the same DB. Sometimes folks apply
> > patches/update to some databases by directly connecting to the DB instead
> > of through pgpool. To fix the problem, I have to restart the service
> > brings down all the applications connected to the pgpool service. These
> > applications now have to create brand new DB connections to continue
> > working which is pretty drastic.
> > Having an option to reset cache in such a scenario without bringing the
> > service down is convenient. Then I just have to take a performance hit
> > till the cache warms up again.
> > -AJ
> > On Thu, May 18, 2017 at 3:16 PM, Tatsuo Ishii <ishii at sraoss.co.jp>
> >> > Is there a way to reset the entire cache without restarting the pgpool
> >> > service using SQL when using shmem?
> >> No. Sorry. Why do you need it?
> >> Best regards,
> >> --
> >> Tatsuo Ishii
> >> SRA OSS, Inc. Japan
> >> English: http://www.sraoss.co.jp/index_en.php
> >> Japanese:http://www.sraoss.co.jp
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the pgpool-general