<div dir="ltr">Hi,<div><br></div><div>After enabling <span id="gmail-docs-internal-guid-7e820b9e-7fff-e572-06e4-e6481df23798"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;vertical-align:baseline;white-space:pre-wrap">memory_cache_enabled = on, got the following in log:</span></span></div><div>2021-07-09 02:53:52: pid 110880: LOG:  error while deleting item from shmem cache, item: 86 was already deleted<br>2021-07-09 02:53:52: pid 110880: LOG:  error while deleting item from shmem cache, item: 86 was already deleted<br>2021-07-09 02:53:52: pid 110880: LOG:  error while deleting item from shmem cache, item: 86 was already deleted<br>2021-07-09 02:53:52: pid 110720: LOG:  pool_reuse_block: blockid: 3</div><div><br></div><div>May I know what might be the cause?</div><div><br></div><div><i> num_cache_hits | num_selects | cache_hit_ratio | num_hash_entries | used_hash_entries | num_cache_entries | used_cache_entries_size | free_ca<br>che_entries_size | fragment_cache_entries_size <br>----------------+-------------+-----------------+------------------+-------------------+-------------------+-------------------------+--------<br>-----------------+-----------------------------<br> 7797           | 33619       | 0.19            | 1048576          | 858               | 858               | 872837                  | 6253433<br>0                | 3663873<br>(1 row)</i><br><div><br></div><div>As per this cache status is it recommended to enable cache?</div><div><br></div><div>Is there any option to enable query caching only for selected tables?</div><div><br></div><div><br></div>Thanks!</div><div><br></div></div>