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년 전844회 조회
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년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠