After a Redshift's Maintenance my queries are too slow

0

It is possible to limit the negative effects of query performance after your cluster maintenance?Thanks

已提问 2 年前845 查看次数
3 回答
1

There are some possible explanations to the behavior you're observing. For example, it is possible that a Redshift software upgrade forces an invalidation of your cluster's global query compile cache if the compile logic was changed as part of the release, but this is just one theory and I would be surprised if this happens with every software upgrade. The best course of action that I can recommend is to open a support ticket, so the AWS/Redshift support team can diagnose your cluster with you in real time.

AWS
asser_m
已回答 2 年前
AWS
专家
已审核 2 年前
  • It could also just invalidate the result cache and the first execution of the query would be slower than subsequent runs.

  • No because the result cache is disabled for my user.I SET enable_result_cache_for_session TO OFF.

  • Do I need to activate the developer support plan to use AWS/Redshift support? Thanks

  • According to the website below, developer support is the first level of support available, but it can be month-to-month (i.e. no long term contracts needed). https://aws.amazon.com/premiumsupport/plans/

0

These maintenances were done early Saturday morning : REDSHIFT-EVENT-3014 REDSHIFT-EVENT-3520 REDSHIFT-EVENT-3519 REDSHIFT-EVENT-2004 REDSHIFT-EVENT-2003 On Saturday during the day I connected to my reports and all queries were very slow. This happens after every amazon maintenance. I haven't tried to contact account support yet, I wanted to find out if this behavior was encountered by other users.

已回答 2 年前
  • Are all FIRST execution of a specific Query slow, and all subsequent runs go back to the execution time you are used to?

  • yes this is the behavior.

0

Hello, to best answer your question, I think a few follow-up questions are needed. For example, you mention cluster maintenance (e.g. Redshift software upgrade), but am wondering if it is really automatic table maintenance that is being referred to (e.g. automatic sort key optimization). Also, is it all queries exhibiting a slow-down or just some queries? Have you tried reaching out to account support or your account solutions architect for help possibly examining your cluster with you in real time?

AWS
asser_m
已回答 2 年前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则