[pgpool-general: 7106] Query cache invalidation for functions?
rick.morris at enterprisedb.com
Sat Jun 27 03:13:31 JST 2020
In testing the in-memory query cache, I find that auto cache invalidation
works for UPDATE and INSERT queries, but does not work when calling plpgsql
Is there any way to auto-invalidate cache for UPDATE/INSERTs within
functions? If not, is there any way to explicitly invalidate the cache with
additional code in a function?
Using PgPool 4.1.1, with the following relevant settings:
memqcache_auto_cache_invalidation = on
memqcache_expire = 0
relcache_expire = 0
enable_shared_relcache = on
memory_cache_enabled = on
black_function_list = 'test_update_function,test_insert_function'
Rick Morris | Managing Consultant, Professional Services & Training (EMEA)
| M: +1 954 224 8682 | Skype: rycamor
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the pgpool-general