A question that I have had for a while that I can't seem to find an answer: for teams that are using various columnar store extensions to turn Postgres into a viable OLAP solution - are they doing so in the same instance of their Postgres that they are using for OLTP? Or are they standing up a separate Postgres instance?
I'm trying to understand if there is any potential performance impact on the OLTP workload by including the OLAP in the same process.
I'm trying to understand if there is any potential performance impact on the OLTP workload by including the OLAP in the same process.