[pgpool-general: 8449] Re: Memory cache

[Tatsuo Ishii]

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