Hi there,
I'm looking to see if anyone in this community has made the shift from a PostgreSQL database on AWS RDS to RedShift, or any OLAP database for that matter.
I'm mostly curious about the transition in the context of transitioning your Retool application(s). Did you realize the desired performance gains, and was transitioning your resources/queries difficult?
Hey @pod2! Thanks for reaching out.
Just for context, are you on a cloud or self-hosted instance? And what kind of data are you looking to store? Generally speaking, OLTP databases have better concurrency and lower latency, whereas OLAP databases are optimized for compute workloads.
On the Retool side, I don't think there's a way to point an existing query towards a different resource. It may be possible to reconfigure an existing resource, though, so that it points towards a different database. 
I hope that helps, if only a bit! I'm happy to answer any additional questions you might have.