Am I correct in thinking that PG's MVCC implementation results in a worse story around offloading some mild OLAP workloads to a replica without affecting the primary? Anecdotally, it
seems that MySQL handles this better but I don't understand the internals of both enough to explain why that is.
https://aws.amazon.com/blogs/database/manage-long-running-re...