Transforming Postgres into a Fast OLAP Database

(in Rust) :)

How does this handle sort ordering / collations?

Thanks for sharing, I really like Postgres. However, I generally use Postgres for OLTP work. I would like to point out two things:

1. Based on Clickbench results, pg_analytics is still far from top-tier performance. If you're looking for a high-performance OLAP database, you should consider the top-ranked products.

2. The queries tested by Clickbench are really simple, far from real data analysis scenarios. You must be aware of the TPC-DS and TPC-H benchmarks, because ClickHouse simply cannot run these test suites, so their Clickbench does not include these datasets.

Lastly, I want to say, if your enterprise is of a certain size, separating OLTP and OLAP into two databases is the right choice, because you will have two different teams responsible for two different tasks. By the way, I use StarRocks for OLAP work.

> Based on Clickbench results, pg_analytics is still far from top-tier performance

You touch on this in your next sentence, but really, how many people need that kind of performance?

If you're looking for pg_analytics (the product in TFA) in the charts and can't find it, it's because the chart calls it ParadeDB (after the company, instead of the product).