1brc merykitty's magic SWAR: 8 lines of code explained in 3k words(questdb.io)

226 points by signa11 2 years ago | 70 comments

A sharded DuckDB on 63 nodes runs 1T row aggregation challenge in 5 sec(gizmodata.com)

196 points by tanelpoder 1 year ago | 121 comments

Solving duplicate data with performant deduplication(questdb.io)

38 points by goodroot 2 years ago | 18 comments

A 40-line fix eliminated a 400x performance gap(questdb.com)

348 points by bluestreak 9 months ago | 75 comments

QuestDB engineering blog post explaining how a 40-line OpenJDK change to getting current thread user CPU time on Linux removed a 400x performance gap.

Building a faster hash table for high performance SQL joins(questdb.io)

71 points by nhourcard 2 years ago | 28 comments

100k TPS over a billion rows: the unreasonable effectiveness of SQLite(andersmurphy.com)

344 points by speckx 10 months ago | 124 comments

Blog post by Anders Murphy benchmarking SQLite at 100k transactions per second over a billion rows, arguing its embedded single-writer design helps it scale.