[pgpool-general: 8117] Re: In memory query cache

Tatsuo Ishii ishii at sraoss.co.jp
Mon May 2 23:00:03 JST 2022


> One more question if I use memcached the eviction is different or working
> the same as shmem?

In case of memcached, the cache storage is managed by memcached
itself, not by pgpool. Thus the eviction is different from shmem.

> On Mon, 2 May 2022 at 13:42 Avi Raboah <avi.raboah at gmail.com> wrote:
> 
>> Thanks a lot.
>>
>> On Mon, 2 May 2022 at 13:33 Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
>>
>>> > Pool_memqcache.c
>>> > Pool_reuse_block
>>>
>>> Ok, the comment "using clock algorithm" is not correct. Actually it
>>> uses simple FIFO instead. I will update the comment.
>>>
>>> > Thanks.
>>> > On Mon, 2 May 2022 at 3:24 Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
>>> >
>>> >> > Hi,
>>> >> >
>>> >> > I am trying to find how piggy pool handle eviction policy in case the
>>> >> cache
>>> >> > is full.
>>> >> >
>>> >> > I saw something about clock algorithm but I am not sure I understand
>>> it.
>>> >> >
>>> >> > Could you please clarify this mechanism?
>>> >>
>>> >> Which source file are you looking at?
>>> >>
>>> >> Best reagards,
>>> >> --
>>> >> Tatsuo Ishii
>>> >> SRA OSS, Inc. Japan
>>> >> English: http://www.sraoss.co.jp/index_en.php
>>> >> Japanese:http://www.sraoss.co.jp
>>> >>
>>>
>>



More information about the pgpool-general mailing list