Hacker News Reader

Assuming you use a connection pool, why would it stop? Either the query returns a result or it doesnt? Am I missing something?

View on HN

Reporting queries can put a significant load on the db, to the point that it interrupts service.

I see, thanks!

Futhermore, Postgres is an OLTP (transactional) database, designed to efficiently perform updates and deletes on individual rows. OLAP (analytical) databases/query engines like Clickhouse, Presto, Druid, etc. are designed for efficient processing across many rows of mostly unchanging data.

Analytical queries (like "find the average sales price across all orders over the past year, grouped by store and region") can be 100-1000x faster in an OLAP database compared to Postgres.

Reply on news.ycombinator.com