清除AWS Redshift上的缓存 [英] Clear cache on AWS Redshift

问题描述

我正在针对AWS Redshift进行测试，并且要复制真实场景，我需要不对我的测试查询进行缓存，以免对性能产生错误的印象.我有什么办法可以在两次查询运行之间清除Redshift缓存?

I am doing testing against AWS Redshift, and to replicate real world scenarios I need my test queries to not be cached so as not to give a false picture of performance. Is there any way for me to clear the Redshift cache between query runs?

推荐答案

我相信您可以通过将值 enable_result_cache_for_session 设置为 off

I believe you can disable the cache for the testing sessions by setting the value enable_result_cache_for_session to off

从文档

如果enable_result_cache_for_session已关闭，则Amazon Redshift将忽略结果缓存并在提交所有查询时执行所有查询.

If enable_result_cache_for_session is off, Amazon Redshift ignores the results cache and executes all queries when they are submitted.

这篇关于清除AWS Redshift上的缓存的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！