We initially thought Redshift(OLAP) would be overkill and too expensive for our app's requirements since we have thousands of live users and thousands of reads.

PSQL is still a robust tool for managing our workload. The key is to understand how to optimize it.