I've worked as a contractor at a company that funnily had a really slow Redshift.
After a bit of investigation me and another developer found out they only had one leader node and no compute nodes and didn't plan to invest in more than one...
So yeah Redshift is fast, unless you use it in a cluster of one where there's no distribution or parallel work. Like that you're probably better off using PostgreSQL :D
Lol that is such a brutally typical type of situation organizations find them in.
We're a place where coders share, stay up-to-date and grow their careers.
We strive for transparency and don't collect excess data.