[pgpool-general: 8450] Re: Memory cache

[j.emerlik]

Thank you

pt., 7 paź 2022, 03:52 użytkownik Tatsuo Ishii <ishii at sraoss.co.jp> napisał:

> Hi,
>
> > Hi,
> > when I was looking for something about differences between shmem and
> > memcached I found:
> >
> > "Shared memory – Fast and easy to use but cache size is limited"
>
> Maybe you found the phrase in my presentation?
>
>
> https://www.sraoss.co.jp/wp-content/uploads/files/event_seminar/material/2012/20121024_pgpool-II_pgconfEU2012_sraoss.pdf
>
> > Then I have question: what is the size limit of shmem ?
>
> The upper limit of shmem size depends on the system defined shared
> memory size.  Unfortunately there is a bug with the query cache system
> which limits the max size of cache to 2GB.  This will be fixed in the
> next minor releases (planned to be released in this November). After
> the fix applied, the upper limit will be same the system shared memory
> size.
>
> Best reagards,
> --
> Tatsuo Ishii
> SRA OSS LLC
> English: http://www.sraoss.co.jp/index_en/
> Japanese:http://www.sraoss.co.jp
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20221007/b5d8592c/attachment.htm>