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 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南