3 ms·
The advantage of OLAP vs. OLTP on analytical queries is clearly visible on the benchmark: https://benchmark.clickhouse.com/ https://benchmark.clickhouse.com/ I
by zX41ZdbW 4y ago
The advantage of OLAP vs. OLTP on analytical queries is clearly visible on the benchmark:
https://benchmark.clickhouse.com/ https://benchmark.clickhouse.com/
If we take the extreme - ClickHouse as the most thoroughly optimized column-oriented DBMS and compare it with Postgres, the difference will be more than 100 times on average.