Postgres Tuning & Performance for Analytics Data
Your database is configured for the needs of your day-to-day OLTP (online transaction processing) application workload, but what if you need to run analytics queries against your application data? How can you do that without compromising the performance of your application?OLTP & OLAP activity in the same database
Application data gradually builds up in your database over time, and at some point the business wants to glean insights from it by running analytics queries.
Analytics activity, sometimes called OLAP (online analytical processing), Reporting, Decision Support (DS) or Business Intelligence (BI) is activity that’s designed to answer real-world business questions. It might be something like "How successful was our last marketing campaign?" or “What's the impact on our CO2 emissions of performing this action compared to this one?"
The business often wants to get answers to these questions in real-time, querying the data where it is rather than setting up a dedicated analytics environment.
