Ability to invalidate multiple caches by tags about pgmemcache HOT 1 OPEN

I don't think the flush command in memcache supports tags, so you'd have to delete all individual keys separately which is pretty clumsy. You could, however, just create your own wrapper functions around pgmemcache that use your custom tags in all operations and just update the tag when you want to stop using the values with the old tag.

One way to do it would be to have a table that contains your tag and SQL language functions that select that tag and prepend or append it to the key you're using. Another way would be to just embed that tag directly in your function definition.

One application I implemented had versioned database tables and functions and always stored values in the database in JSON format with the current software version included in the value. That way the keys remained the same across software versions (and different software versions running simultaneously wouldn't see different data), but if the software version on the frontend didn't match the version in the cached value the cache was ignored.

from pgmemcache.