A few other things I can think of as well - you'd probably at least want a read replica so you're not running queries on your primary db - if you're going to

A few other things I can think of as well - you'd probably at least want a read replica so you're not running queries on your primary db - if you're going to the trouble of setting up a column store, it seems likely you're wanting to integrate other data sources so need some ETL regardless - usually column store is more olap with lower memory and fast disks whereas operational is oltp with more memory and ideally less disk io usage I suppose you could get some middle ground with PG logical rep if you're mainly integrating PG data sources