[pgpool-general: 8221] Cache_unsafe_memqcache_table_list not working on reload

Avi Raboah avi.raboah at gmail.com
Thu Jun 16 22:21:55 JST 2022


I did the following:

1. Select * from city limit 1;
2. Add city to unsafe configuration.
3. Reload pgpool.
4. Select * from city limit 1; # return from the cache.

I expected that pgpool after adding the table to the unsafe will not return
the same query from the cache.

I check the code and I saw that pgpool not check if the query is from table
which included in the unsafe configuration. Means pgpool check only in
store and not in fetch.

Any thoughts? This is a bug?


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20220616/f9afc2ca/attachment.htm>

More information about the pgpool-general mailing list