By using AWS re:Post, you agree to the Terms of Use

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?

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.

answered 5 months 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
answered 5 months 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.

Guidelines for Answering Questions