[pgpool-general: 8354] Re: Cache entries

Avi Raboah avi.raboah at gmail.com
Tue Aug 16 17:49:50 JST 2022

Ok thanks.

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

Thanks, Avi

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
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20220816/3798f65f/attachment.htm>

More information about the pgpool-general mailing list