//
Search across all documentation pages
7 pages in this section.
Why OLTP and OLAP workloads pull PostgreSQL's tuning knobs in opposite directions, and the mental model for reconciling both on one cluster.
Understand the fundamental differences between OLTP and OLAP workloads and how to configure PostgreSQL for each to optimize performance.
Optimize mixed OLTP/OLAP workloads in PostgreSQL. Learn to route BI to replicas, set role defaults, and review primary activity.
A single-page roundup of every highlight bullet from the 6 pages in the OLTP vs OLAP section, grouped by source page so you can scan all 35 takeaways without opening each article individually.