Improvement of Remote Filesystem Cache and SYSTEM DROP FILESYSTEM CACHE Enhancements

Why it matters

This feature enhances the efficiency of reading from the remote filesystem cache, reducing latency and improving data retrieval speeds. Additionally, it provides more control over cache management by allowing targeted cache invalidation using the <path> option and the ability to forcibly drop cache entries with the FORCE option. This improves cache maintenance and reliability for users managing large or remote datasets.

How to use it

To utilize the improvements, users can run the SYSTEM DROP FILESYSTEM CACHE query with optional parameters. Use SYSTEM DROP FILESYSTEM CACHE <path> to drop the cache for a specific path and add the FORCE keyword to forcibly clear cache entries. Reading from the remote filesystem cache is automatically improved without additional configuration.