[pgpool-general: 8354] Re: Cache entries

[Avi Raboah]

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
> SRA OSS LLC
> 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>