En utilisant AWS re:Post, vous acceptez les AWS re:Post Conditions d’utilisation
AWS re:Postre:Post

Queries to Redshift Information Schema very slow

0

Since the last maintenance release we have noticed that queries to the information schema on our Redshift cluster are incredibly slow - previously they were taking < 1 second but now are taking around 10 mins. Is there anything that has happened in the release to cause this or anything I can do on the cluster myself to improve performance?

Sujets
Base de donnéesAnalytique
Balises
Extraire, transformer et charger des donnéesAmazon Redshift
Langue
English
AWS-User-0724223
demandé il y a 2 ans409 vues
2 réponses
0

I would suggest creating a support ticket for this, before trying to tune it up. This isn't something that should be happening, most probably not your fault.

AWS
AWS-ADolganov
répondu il y a 2 ans
0

Please create a AWS Support case, with information including

  • the cluster name/region
  • query text
  • query IDs of the same query when it's fast and when it's slow
  • when the issue started
  • anything else you'd like to mention
AWS
AWS-supipi
répondu il y a 2 ans

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions

Contenus pertinents