[pgpool-general: 7106] Query cache invalidation for functions?

Rick Morris 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...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20200626/6847e8d2/attachment.html>

More information about the pgpool-general mailing list