ClickHouse/ClickBench on Hacker News

…s://pgrust.com/downloads/archive/2026-09-clickbench-snap... [2] https://benchmark.clickhouse.com/ [3] https://github.com/ClickHouse/ClickBench/pull/2751

comment by malisper · 2026-11-02 · in Postgres 19 is late because so many more bugs are being found now

Previous attempts were strange, to say the least: https://github.com/ClickHouse/ClickBench/pulls?q=is%3Apr+par...

comment by zX41ZdbW · 2026-10-31 · in Jepsen: ParticleDB 1.1.4

https://github.com/ClickHouse/ClickBench/pull/2952

comment by throwaway737488 · 2026-10-31 · in Jepsen: ParticleDB 1.1.4

…and costs 24x as much. Edit: And now it's been accepted: https://benchmark.clickhouse.com/ [0] https://github.com/ClickHouse/ClickBench/commit/56535d29e825... [1] https://github.com/ClickHouse/ClickBench/commit/89cc76e1e4e2...

comment by malisper · 2026-10-25 · in We should be more ambitious with the software we build

…results for -beta are in[0]. The geomean across all runs came out as 7% faster than -preview[1] [0] https://github.com/ClickHouse/ClickBench/commit/56535d29e825... [1] https://github.com/ClickHouse/ClickBench/commit/89cc76e1e4e2...

comment by malisper · 2026-10-25 · in Remove pgrust: the entry is cheating (per-query kernels and result caching)

…go a long way. unfortunately though pgrust appears to be at best misleading, at worst vibeslop: https://github.com/ClickHouse/ClickBench/pull/2165 hacknews thread isn’t much prettier either https://news.ycombinator.com/item?id=50205816

comment by 0conclusive-dem · 2026-10-25 · in We should be more ambitious with the software we build

For those curious, see the accusation here https://github.com/ClickHouse/ClickBench/pull/2165 and then the HN thread https://news.ycombinator.com/item?id=50205816 HN is waiting for the source code for pgrust 0.4-preview to be released, the…

comment by hitekker · 2026-10-25 · in We should be more ambitious with the software we build

…[1] https://pgrust.com/downloads/archive/2026-09-clickbench-snap... [2] https://github.com/ClickHouse/ClickBench/blob/main/README.md [3] https://clickhouse.com/docs/concepts/features/performance/ca... [4] https://github.com/ClickH

comment by malisper · 2026-10-23 · in Remove pgrust: the entry is cheating (per-query kernels and result caching)

…the issue and attempts to correct the mistake, which clearly seems to have happened here: https://github.com/ClickHouse/ClickBench/pull/2751 Most of this thread doesn't seem to acknowledge that, and feels more like anti-ai psychosis using…

comment by acalvino4 · 2026-10-23 · in Remove pgrust: the entry is cheating (per-query kernels and result caching)

…ClickBench driver over the step scripts in this directory; ./install fetches the dataset. [1] https://github.com/ClickHouse/ClickBench/pull/2751/files

comment by mschuster91 · 2026-10-23 · in Remove pgrust: the entry is cheating (per-query kernels and result caching)

2nd round: https://github.com/ClickHouse/ClickBench/pull/2751

comment by drchaim · 2026-10-23 · in Remove pgrust: the entry is cheating (per-query kernels and result caching)

▲ 198

Remove pgrust: the entry is cheating (per-query kernels and result caching)

story by f311a · 2026-10-23 · 166 comments

…project was in August 2023 so not quite few months old. And the performance problem according to https://github.com/ClickHouse/ClickBench/pull/1159 has not been yet solved. So, I think my curiosity still stands.

comment by menaerus · 2026-10-02 · in Supabase is acquiring Turso

…it to ClickBench, but each time new bugs were found. It should not be X times slower than SQLite. https://github.com/ClickHouse/ClickBench/issues/336 https://github.com/ClickHouse/ClickBench/pull/1009

comment by f311a · 2026-10-02 · in Supabase is acquiring Turso

Let's add it to ClickBench: https://github.com/ClickHouse/ClickBench/

comment by zX41ZdbW · 2026-08-14 · in RayforceDB – a pure C analytics database with a Lisp-like syntax

…firecracker microvms that exposes a small /query endpoint. A monitor records and posts results. https://github.com/ClickHouse/ClickBench/tree/main/playgroun... Was a little hard to find in the changelog myself (unaided) since there has…

comment by jauntywundrkind · 2026-08-05 · in Show HN: ClickBench Playground – a playground for 110 database systems

Done! https://github.com/ClickHouse/ClickBench/pull/1163

comment by malisper · 2026-07-31 · in Pgrust v0.2: Now faster than Postgres and Clickhouse Latest

I tried pgrust on ClickBench recently, but it didn't work at all: https://github.com/ClickHouse/ClickBench/pull/983#issuecomme...

comment by zX41ZdbW · 2026-07-27 · in Pgrust was built: four attempts to rewrite Postgres in Rust with AI

I tried pgrust on ClickBench recently, but it didn't work at all: https://github.com/ClickHouse/ClickBench/pull/983#issuecomme...

comment by zX41ZdbW · 2026-07-27 · in Postgres in Rust: three dead ends before we passed 100% of the regression suite

https://github.com/ClickHouse/ClickBench/pull/983

comment by zX41ZdbW · 2026-07-20 · in Postgres rewritten in Rust, now passing 100% of the Postgres regression tests

…Namely sysbench-tpcc[0] and clickbench[1] [0] https://github.com/Percona-Lab/sysbench-tpcc [1] https://github.com/ClickHouse/ClickBench

comment by malisper · 2026-07-09 · in Postgres rewritten in Rust, now passing 100% of the Postgres regression tests

…issues if the file changes, as BQNs arrays are immutable). This is also what caused the problem at https://github.com/ClickHouse/ClickBench/pull/939/changes/40... (there's been some discussion about what to do about invalid •bit._cast…

comment by dzaima · 2026-07-07 · in l: A new runtime for k and q

…If anyone is curious how queries in this language look, you can see it here: https://github.com/ClickHouse/ClickBench/pull/939/changes#di...

comment by zX41ZdbW · 2026-07-07 · in l: A new runtime for k and q

…that shows how difficult it is to really asses performance effects of even "small" changes. [3] [1] https://github.com/ClickHouse/ClickBench#data-loading [2] https://www.youtube.com/watch?v=CAS2otEoerM [3]…

comment by ozgrakkurt · 2026-06-25 · in Lies, Damn Lies and Database Benchmarks

I've been trying for more than a year to make TursoDB load a single file, and it fails: https://github.com/ClickHouse/ClickBench/issues/336

comment by zX41ZdbW · 2026-05-15 · in We are retiring our bug bounty program

Hm, our internal benchmarking shows something like a 30x speedup compared to SQLite ( https://github.com/ClickHouse/ClickBench shows an even greater speedup due to not considering cache size). Calculating back on the envelope I'd estimate…

comment by goerch · 2026-04-22 · in DuckDB 1.5.2 – SQL database that runs on laptop, server, in the browser

This is good news. I was trying to add Exasol to ClickBench ( https://github.com/ClickHouse/ClickBench/ ) since 2016, but it was not possible due to the limitations and the fact that it required using a custom virtual machine image. Now we…

comment by zX41ZdbW · 2026-01-16 · in Exasol Personal – Democratizing Big Data Analytics

…load some data, but it is so slow that even several months are not enough to load the dataset: https://github.com/ClickHouse/ClickBench/issues/336

comment by zX41ZdbW · 2025-11-03 · in Notes by djb on using Fil-C

I don't think that's right, it looks to be a set of 43 queries with zero joins: https://github.com/ClickHouse/ClickBench/blob/main/versions/...

comment by Boxxed · 2025-06-03 · in ClickHouse raises $350M Series C

…For instance, clickbench is comprised of >40 queries and there's not a single join in them: https://github.com/ClickHouse/ClickBench/blob/main/clickhous...

comment by Boxxed · 2025-05-29 · in ClickHouse raises $350M Series C

people tried to run spark (better hadoop) and failed lol. https://github.com/ClickHouse/ClickBench/pull/139

comment by zhousun · 2025-03-08 · in Postgres Just Cracked the Top Fastest Databases for Analytics

…[2] https://docs.victoriametrics.com/victorialogs/sql-to-logsql/ [3] https://github.com/ClickHouse/ClickBench/tree/main/victorial...

comment by valyala · 2025-02-14 · in SQL pipe syntax available in public preview in BigQuery

Some examples from me: Database benchmarks: https://github.com/ClickHouse/ClickBench (containing 30+ databases) and the new JSON analytics benchmark, https://github.com/ClickHouse/JSONBench/ Plus, the hardware benchmark:…

comment by zX41ZdbW · 2025-02-11 · in Backblaze Drive Stats for 2024

…to understand even if you aren't familiar with LogsQL. See how to convert SQL to LogsQL [4]. [1] https://github.com/ClickHouse/ClickBench/tree/main/victorial... [2] https://github.com/ClickHouse/ClickBench/blob/main/clickhous... [3]…

comment by valyala · 2025-01-28 · in VictoriaLogs Beats Elasticsearch, MongoDB and PostgreSQL in ClickBench

▲ 13

VictoriaLogs Beats Elasticsearch, MongoDB and PostgreSQL in ClickBench

story by valyala · 2025-01-28 · 1 comment

…Pinot in their benchmarks, which is one of Pinot's main selling points on the performance front - https://github.com/ClickHouse/ClickBench/issues/37 .

comment by shadow28 · 2024-12-06 · in 7 Databases in 7 Weeks for 2025

…I would suggest you check out pg_lakehouse. It's even more performant than pg_analytics, see here: https://github.com/ClickHouse/ClickBench/pull/208

comment by philippemnoel · 2024-07-13 · in Putting DuckDB in Postgres to Query Iceberg

Umbra in ClickBench: https://github.com/ClickHouse/ClickBench/pull/161 The initial submission didn't reproduce successfully due to a segmentation fault in an attempt to restart it after data loading. But after some changes, it started to…

comment by zX41ZdbW · 2024-05-02 · in Umbra: A Disk-Based System with In-Memory Performance [pdf]

…ALL the data in your database, and GROUP BY one of the 100 columns in the web analytics logs. - https://github.com/ClickHouse/ClickBench/blob/main/clickhous... There are almost no time-predicates in the benchmark that Clickhouse created,…

comment by mfreed · 2024-04-16 · in Loading a trillion rows of weather data into TimescaleDB

I have a project dedicated to this topic: https://github.com/ClickHouse/ClickBench It is important to explain the limitations of a benchmark, provide a methodology, and make it reproducible. It also has to be simple enough, otherwise it…

comment by zX41ZdbW · 2024-03-10 · in Fair Benchmarking Considered Difficult (2018) [pdf]

…open source benchmark - we'd love contributions from Timescale enthusiasts if we missed something: https://github.com/ClickHouse/ClickBench/

comment by tbragin · 2024-02-04 · in Why Postgres RDS didn't work for us

…love for you or someone in the community to benchmark Stanchion in ClickBench and submit results! ( https://github.com/ClickHouse/ClickBench/ ) Disclaimer: I work on ClickHouse.

comment by tbragin · 2024-02-01 · in Show HN: Stanchion – Column-oriented tables in SQLite

▲ 1

ClickBench: A Benchmark for Analytical Databases

story by tosh · 2024-01-22 · 0 comments

Looks like a recent PR bumped benchmark.clickhouse.com to DuckDB v0.9 on the 3rd. https://github.com/ClickHouse/ClickBench/pull/141

comment by jabart · 2023-11-06 · in Updates to the H2O.ai db-benchmark

…comparable with ClickHouse. Even loading a table with 100M rows is not an easy endeavor in Pinot: https://github.com/ClickHouse/ClickBench/blob/main/pinot/ben...

comment by zX41ZdbW · 2023-09-19 · in Apache Pinot 1.0

I tried Boiling Data, but the product looks dead or abandoned: https://github.com/ClickHouse/ClickBench/issues/125 It does not work at all.

comment by zX41ZdbW · 2023-09-13 · in A LLM+OLAP Solution

Also I recommend to read the methodology here: https://github.com/ClickHouse/ClickBench/blob/main/README.md Making an open-source, easily reproducible benchmark with clear rules allowed having more than 30 different DBMS in a single…

comment by zX41ZdbW · 2023-09-09 · in Common Pitfalls in Database Performance Testing (2018) [pdf]

…Postgres (tuned) are somehow aligned. But what Postgres (tuned) also creates are bunch of indexes ( https://github.com/ClickHouse/ClickBench/blob/main/postgresq... ) which adds around ~50GB of extra storage.

comment by _nvp · 2023-08-25 · in Hydra: Column-Oriented Postgres

https://github.com/ClickHouse/ClickBench/blob/main/postgresq... basically larger buffers and more concurrent workers.

comment by rspijker · 2023-08-25 · in Hydra: Column-Oriented Postgres

> 0 - https://github.com/ClickHouse/ClickBench/blob/main/postgresq ... that postgres config is very underpowered, it has only 8 workers per gather while machine has 192 vcpus.

comment by riku_iki · 2023-08-03 · in Show HN: Hydra 1.0 – open-source column-oriented Postgres