[pgpool-general: 7638] Pgpool query caching
valsaraj pv
valsarajpv at gmail.com
Fri Jul 9 19:21:08 JST 2021
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>
More information about the pgpool-general
mailing list