[pgpool-general: 7638] Pgpool query caching

[valsaraj pv]

Hi,

After enabling memory_cache_enabled = on, got the following in log:
2021-07-09 02:53:52: pid 110880: LOG:  error while deleting item from shmem
cache, item: 86 was already deleted
2021-07-09 02:53:52: pid 110880: LOG:  error while deleting item from shmem
cache, item: 86 was already deleted
2021-07-09 02:53:52: pid 110880: LOG:  error while deleting item from shmem
cache, item: 86 was already deleted
2021-07-09 02:53:52: pid 110720: LOG:  pool_reuse_block: blockid: 3

May I know what might be the cause?







* num_cache_hits | num_selects | cache_hit_ratio | num_hash_entries |
used_hash_entries | num_cache_entries | used_cache_entries_size |
free_cache_entries_size | fragment_cache_entries_size
----------------+-------------+-----------------+------------------+-------------------+-------------------+-------------------------+-------------------------+-----------------------------
7797
          | 33619       | 0.19            | 1048576          | 858
      | 858               | 872837                  | 62534330
   | 3663873(1 row)*

As per this cache status is it recommended to enable cache?

Is there any option to enable query caching only for selected tables?


Thanks!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20210709/b647f0e2/attachment.htm>