Queries to Redshift Information Schema very slow

Question

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?

Answer

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

Answer

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.

Queries to Redshift Information Schema very slow

相關內容