DEV Community

Cover image for The R.A.G (Redshift Analyst Guide): Distribution

The R.A.G (Redshift Analyst Guide): Distribution

Alex Antra on November 14, 2019

Welcome to the R.A.G, a guide about Amazon's Redshift Database written for the Analyst's out there in the world who use it. Previously...
Collapse
 
adamtokarski profile image
Adam Tokarski

Hi, awesome series, it helps me a lot to understand bit after bit.

I have one question though, you wrote "Because the Leader Node won't return it's results until all Compute Nodes have finished,in the above scenario nodes one, two and four would finish way faster than Three and Three would act as a bottleneck." In which case? If I understood correctly, the leader node should cut off these overloaded nodes in case when I'd have query with filter for, say, only Customer Two.

Would it be a bottleneck when I had an aggregation for all customers then?