Performance issue on c6a.metal vs c6a.4xlarge and chDB vs clickhouse-local

chdb-io / chdb

chDB is an in-process OLAP SQL Engine 🚀 powered by ClickHouse

https://clickhouse.com/docs/en/chdb

Apache License 2.0

2.03k stars 72 forks source link

Open auxten opened 1 month ago

auxten commented 1 month ago

chDB (Parquet, partitioned) c6a.metal is slower than c6a.4xlarge on Q0-Q7, Q36-Q42

chDB (MergeTree) c6a.metal is slower than c6a.4xlarge on Q1-Q7, Q36-Q42

chDB (Parquet, partitioned) and chDB(MergeTree) is 3~4 times slower than ClickHouse (Parquet, partitioned) on c6a.metal, 500gb gp2 for Q4, Q5, Q29