# Outgrowing Postgres: optimize and integrate OLTP + OLAP stack

DevFeed: [Outgrowing Postgres: optimize and integrate OLTP + OLAP stack](<https://devfeed.tech/articles/outgrowing-postgres-optimize-and-integrate-oltp-olap-stack-18592.md>)

Original publisher: [Read original article](<https://www.tinybird.co/blog/outgrowing-postgres-how-to-optimize-and-integrate-an-oltp-olap-stack>)

Author: Ariel Pérez

Published: 2025-02-27T00:00:00Z

Content type: tutorial

Language: en

Sources: [Tinybird](<https://devfeed.tech/sources/tinybird.md>)

Topics: [olap](<https://devfeed.tech/topics/olap.md>), [Transactions](<https://devfeed.tech/topics/transactions.md>)

Tags: [analytics](<https://devfeed.tech/tags/analytics.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [olap](<https://devfeed.tech/tags/olap.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [scale](<https://devfeed.tech/tags/scale.md>), [the-data-base](<https://devfeed.tech/tags/the-data-base.md>)

## AI overview

This tutorial explains how to optimize Postgres for analytics and when to integrate an OLAP system alongside its transaction-processing workload.

## Source excerpt

Postgres handles transactions fine but chokes on analytics at scale. Here's how to optimize it and when to add OLAP.