>Lastly, we set a key objective to reduce synchronous operations on >PostgreSQL. We moved many operations from synchronous PostgreSQL >operations to our offline, queue-based analytics layer. One of our heaviest >operations involves conversion funnel queries, and these were moved from >direct PostgreSQL queries to our Spark-based analytics query system.
IMHO, running heavy BI/analytics SQLs on a slave is much easier, and doesn’t request architecture change