[pgpool-general: 8354] Re: Cache entries
avi.raboah at gmail.com
Tue Aug 16 17:49:50 JST 2022
Moreover I found something very weird.
In case you add something to unsafe table in order not to cache queries
from this table.
Pgpool still increment num selects with those queries and this increase
harm the cache hit ratio.
I am missing something?
Unsafe = city
Select from city … let’s say 10 times
Show pool_cache will show
Num selects = 10
On Tue, 16 Aug 2022 at 4:27 Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
> > Hi,
> > There is a way to see what entries are stored in shared memory cache?
> No. I have to admit that such a feature could be useful, though.
> Best reagards,
> Tatsuo Ishii
> SRA OSS LLC
> English: http://www.sraoss.co.jp/index_en.php
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the pgpool-general