Last week the good old Gunnar Morling launched an interesting challenge about ordering 1 billion rows... Tagged with clickhouse, postgres, sorting.

Denis Bolkovskis

Anthropic

Community Picks is a section on daily.dev where our community members share the most interesting and valuable content they've discovered online. From insightful articles to handy tools, every post is a gem curated by our dedicated coomunity. To contribute to Community Picks, you need to have at least 250 reputation points, ensuring that only active and trusted members can share their finds.

Community Picks

This post discusses the process of ordering 1 billion rows in Java using PostgreSQL and ClickHouse. It covers generating the data, setting up local databases, loading the data, running queries, and comparing the results. The post highlights the faster performance of ClickHouse compared to PostgreSQL for querying directly from a CSV file.

1 billion rows challenge in PostgreSQL and ClickHouse