ClickHouse

Data

ClickHouse vs. Postgres for analytics: a field report

We pushed both at a billion rows and measured everything. The answer wasn't "use the fast one"; it was knowing which questions each database was built to answer.