There's no API for indices depending on other indices. You can only build the cache in memory and drop the cache on any PSI change that might affect your underlying index.
Yes, but you'd still need to invalidate it either very often or in a very smart way. That's quite hard to do, and in most cases one can solve the problem without that.
There's no API for indices depending on other indices. You can only build the cache in memory and drop the cache on any PSI change that might affect your underlying index.
So if I want to use persistant cache I have to do it on my own?
Yes, but you'd still need to invalidate it either very often or in a very smart way. That's quite hard to do, and in most cases one can solve the problem without that.
Thank you a lot!