Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re: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?

Topics
AnalyticsDatabase
Tags
Extract Transform & Load DataAmazon Redshift
Language
English
asked 4 years ago685 views
2 Answers
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
answered 4 years ago
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
answered 4 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Relevant content