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

preguntada hace 2 años844 visualizaciones
3 Respuestas
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
respondido hace 2 años
AWS
EXPERTO
revisado hace 2 años
  • 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.

respondido hace 2 años
  • 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
respondido hace 2 años

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas